Recent content by Robert2019

The database is still small enough, testing size, that I ran as a select query and filtered the table and can't find the duplicates. But, as I'm rebuilding it in yesterday's copy, I'm thinking that the problem may be multiple tables have a primary key labeled--ID. Even though when I query them...

Okay, thanks Micron. There are three indexed fields. The primary (no duplicates0, the invID, and the resourceID. The last two permit duplicates as there can be ten campuses paying a share of each resource per invoice. Fortunately, I sent a copy of this database to the potential client...

Sorry about truncating the error message. I thought it was standard from there out: "Microsoft Office Access set 0 fields to null due to a type conversion failure, and it didn't add 8 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation...

I have a query that appends data to an existing table. This query is run from a form. It sets query criteria from one field in the form. It's been working great for weeks. It worked yesterday. I created another append query to append data that's calculated differently and to be appended to the...