What does this error message mean?

[jparker1954]

I am getting the following message when I try to run an append query for a database that I am editing. What I don't know is, does this mean I only have a type conversion failure, or do I have several things I need to fix?

[rpeare]

Typically you get that message when you're trying to append a text value to a number field or a decmial value to an integer field, etc. Usually a data type mismatch.

[Micron]

It's a generic message meant to cover 4 possible reasons why an action query cannot act against every record that it should. Each potential is reported and a count given for the reason, but those that don't apply are reported as zero. Unless you know it's OK, you should probably cancel until you fix the problem, which could be at the table level or query itself.

[jparker1954]

Thanks! You were correct. I happened to accidentally change a field from text to number in the original database, so got that message when I tried to append. All fixed now.