View Single Post
Old 07-12-2019, 02:59 PM   #8
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,191
Thanks: 10
Thanked 226 Times in 214 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Type conversion error in append query that worked minutes ago

Quote:
they've got some altered label,
Your fields might have captions, which could confuse you. In table design, see what the field name is and look at the property sheet for the caption property (or review them and switch back to datasheet view if you can remember what is what). I agree, ID makes a poor name for a field and can cause design mistakes when so many have the same name.
Good luck!
Micron is offline   Reply With Quote