Susan Harkins
ssharkins at gmail.com
Tue Jul 19 05:46:36 CDT 2011
No, they were both text -- I checked that and Access automatically knew that the field was text and took care of it for me. I never call myself an expert. :) Susan H. > > Your query may have tried to update a text 20 to a numeric 21, which would > have been the wrong type and should not have worked. > > Just a guess ... > > Dan > > PS - Don't ever tell anyone you're an expert. As soon as I said it - I > wasn't! :-(