Data type mismatch in criteria expression.

[KERRYDEE]

I am new to this forum so please forgive me if I make a mistake in asking this question.

1. Manufacture
2. Model
3.SerialNumber
4.Sizes
5.SerialTypes
6ServiceDatePicker
7.Results.

I created combo boxes on the original Access Template forms to select from the tables above.



I keep getting the following error and my refresh total is not working. I checked to ensure that my table fields were filled with text for text entries, etc.

USysApplicationLog
SourceObject
LineItemCodes.GetDetails
USysApplicationLog
Description
Data type mismatch in criteria expression.

Any help will be tremendously appreciated.

[CJ_London]

Data type mismatch in criteria expression

Criteria is the bit of your query which follows WHERE. Datatype mismatch means you are trying to compare different datatypes (text, number, date etc)

e.g.

SELECT *
FROM myTable
WHERE myTable.ID="3"

ID's are numbers, "3" is text so mismatched

should be

....
WHERE myTable.ID=3

for a more focused answer, please provide the sql to your query

This often happens when you use lookups in a table design - the value stored is actually a number, but what you see is text. Although they seem like a good idea, in reality they waste a lot of time, will slow your processing down and lots of other issues, So if you are using them, remove them.

[KERRYDEE]

Thank you very much!!! I did have lookup field in my table.