Append Query Error

[Rik_StHelens]

Hi,

I have an append query which archives some data depending on the status of the record.

I get the following error message:

"Microsoft Access set 2 field(s) 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 (0) records due to validation rule violations"

I have seen a few other forums with this topic on them, but they all have a number in the error message explanation, so they are of no help. How come this is happening?

Thanks for your time

 

[namliam]

type conversion failure

You have one or more fields in your target table with a different field type than in your original table.

 

[Rik_StHelens]

Superb

Thanks.