View Single Post
Old 07-12-2019, 02:59 PM   #8
Micron
Newly Registered User
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 797
Thanks: 10
Thanked 161 Times in 155 Posts
Micron will become famous soon enough Micron will become famous soon enough
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