Error 3464

[1starr]

This is the error message I keep getting when I run my query: 3464: Data type mismatch in criteria expression. If anyone knows what this means please let me know. Thank You.

 

[ColinEssex]

This is from a simple search of Access help...........

"Verify that the criteria you specified is for the same data type as the data in the underlying table or query. For example, the field ReorderLevel has a Number data type. Therefore, if you type the criteria "50", you'll get an error because Microsoft Access interprets values in quotation marks as text, not numbers.

Other situations that cause a data type conflict include:

· You're specifying criteria for a Lookup field and the criteria uses the values that display on the lookup list instead of their associated foreign key values. Because the foreign key values are the values actually stored in the underlying table, you should use them when you specify criteria for a field. You typed the dollar sign ($) in criteria you specified for a Currency field. Remove the dollar sign, and then view the results.

· Verify that the data type of each pair of joined fields in the query is the same. If not, change the data type of one of the joined fields to match the data type of the other. "

Col

 

[1starr]

Thanks

 

[1starr]

Data type mismatch

I have narrow the problem down. I wrote code where a list box pops up and the user gets to select one of many dates which appears as 10-Oct-03 for example. The problem is that once the user selects the date it is pass through the code as 10-10-03 and by the time it is pass to the query where I have set the criteria “FindDate()” which is looking for 10-Oct-03 I get the error “Data type mismatch in criteria expression.” Does anyone know a way of correcting this problem?

 

[ColinEssex]

Post the code for the function FindDate()

 

[1starr]

Here is the query:
SELECT [CERT June].Category, [CERT June].Weight, [CERT June].Status, [CERT June].Domain, [CERT June].DateofSRR
FROM [CERT June] RIGHT JOIN Status ON [CERT June].Status = Status.Status
GROUP BY [CERT June].Category, [CERT June].Weight, [CERT June].Status, [CERT June].Domain, [CERT June].DateofSRR
HAVING ((([CERT June].Domain)=FindDomain()) AND (([CERT June].DateofSRR)=FindDate()))
ORDER BY [CERT June].Category, [CERT June].Weight;