View Single Post
Old 07-12-2019, 12:14 PM   #3
Newly Registered User
Join Date: Jul 2019
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Robert2019 is on a distinguished road
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.

Robert2019 is offline   Reply With Quote