Re: Type conversion error in append query that worked minutes ago
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 rule violations."
The query with or without the append setting finds 8 records, which is the correct number to find. If I turn off the append I get eight records, and all fields look correct. They are (appear to be) number fields as they should.
Edit: The table I'm appending to has an autonumber field and I am not trying to put any of my queried fields into that field nor do they have a label of ID.