Access error message: "Data type mismatch in criteria expression"

[Pete]

New to Access, acquired a database that is now giving me this error & do not
know where to look for a resolution. When I try to update the database I get
this error message: "Data type mismatch in criteria expression". Any help
would be greatly appreciated.

 

[Roger Carlson]

You haven't given us much to go on. All I can say is that somewhere you are
trying to put the wrong type of data into a field. For instance, you might
be trying to put text data (ABC) into a numeric field.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Pete]

Thank you Roger, I will look into this & see if I can find a place in my
folders that I search where I do not have the correct format. That is what I
needed to know... at least this is a place to start, thanks again.

 

[Pete]

Outstanding Roger, thank you... I did in fact find an Excel folder that had a
column that needed to be formatted as "Text" & was not. Thanks for all your
help, Pete

 

[John W. Vinson]

New to Access, acquired a database that is now giving me this error & do not
know where to look for a resolution. When I try to update the database I get
this error message: "Data type mismatch in criteria expression". Any help
would be greatly appreciated.

You have an error in the query that you're trying to update, probably using a
Text criterion on a Number field (such as a Lookup Field, which looks like it
contains text but actually contains a concealed numeric ID). Please open the
query you're using in SQL view and post it here if you would like help.

 

[Tony Toews [MVP]]

New to Access, acquired a database that is now giving me this error & do not
know where to look for a resolution. When I try to update the database I get
this error message: "Data type mismatch in criteria expression". Any help
would be greatly appreciated.

How are you trying to update the database? Using a form? Datasheet
view? Compact and repair?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/