Running into error while writing Append Query



I'm trying to write an Append query to copy Employee numbers from one table
to another table. The Source table is left joined to the Destination table.
The QEB is set up as below:
Field: txtEmployeeNumber txtEmplNbr
Table: tblEmployee tblTime&SvcAwds
Appendto: txtEmpNbr
Criteria: Is Null

When I try to run the query, I keep getting the following error message:
"Tracker set 0 Field(s) to Null due to a type conversion failure, and it
didn't add 1 record(s) to the table due ot key violations, 0 record(s) due to
lock violations, and 0 record(s) due to validation rule violations."
Thank you,

Jeff Boyce


If the error message is to be believed (always a bit of a gamble...<g>), one
of the records you are trying to append has a key (primary key or unique
index) value that already exists in the append-to table.

Check your data -- if you change that Append query to a Select query, you
can look over what would be added.


Jeff Boyce
Microsoft Office/Access MVP


OK, I fixed that by making a new field in the destination table with an
AutoNumber ID as the Primary Key. When I run it as a Select Query, it shows
me the Employee number, but when I try to do it as an Append Query, it
creates a new AutoNumber ID however it is not copying the employee number
onto the table.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question