Data Type Mismatch - Microsoft Access Forum


	Back to Access Forum Comments List

Data Type Mismatch

Natallia Belaya

5 years ago

Hi all! I get an error too Data type mismatch in criteria expression and cant figure out where I messed up.
FA_CID = DLookup (FA_CID, RateResetMakeTableT, TranNo = & Forms!LoanTicketAddNewF!TranNo)

FA_CID = is Field name on the form. It is a customer Short Name. Its a text
TranNo (transaction#) is done as MakeTableQ as short text as well. Its 6 digit number (for ex.123456) but it was converted from LD00123456 from the original data base where its short text. By this 6 last digit I need to find the rest of the information. Here is a customer short name

Please help! :)
Thank you

	Scott Axton @Reply 5 years ago
Richard / Alex - Maybe this should be in it's own topic? Doesn't really pertain to OP's issue. Natalia - Just based on your field names it appears to me that you are mixing Short Text and Number data types. Your issue is not very clear to me. It would help if you could give an example of what data you have and what you are trying to do with it.

	Richard Rost @Reply 5 years ago
Scott: yeah, I'm going to start closing threads after there have been no replies for 30 days to stop this from happening. Natallia: you just need to review how to use DLookup. Your field name, table name, and criteria need to be inside quotes. `ID = DLookup("FieldName", "TableT", "Criteria=" & ID)`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen