Error on Append Query

[Carl Foster]

Hi

I've just created and append query. On running the query it displays this message:

Microsoft Access can't append all the records in the append query

Microsoft Access set 0 fields to Null due to a type conversion failure, and it didn't add 0 records to the table due to key violations, 0 records due to lock violations, and 3 records due to validation rule violations.
Do you want to run the action query anyway?

I clicked Yes, but still the query didn't work and the 3 records that needed to be appended didn't appear in the table.

Any idea what I could be doing wrong?

 

[David Eagar]

Common causes are: you are trying to add a duplicate record, or text into a numeric field. Double check the data you are trying to enter

 

[Carl Foster]

Thanks, found the problem. One of the fields in the table I was trying to append the data to was a required field but I didn't update that field with the append query.