I'm trying to make a query in Access 2010, but it keeps giving me this error "Data type mismatch in criteria expression."
The query is simple as
SELECT *
FROM mytable
WHERE date = '23-07-2013'
Any wonder why?
SELECT *
FROM mytable
WHERE date = #7/23/2013#
Access enclosed a date with # signs to indicate a literal value of date. And using a single quote in your case means you are comparing a String/Text with a Date data type thus the Data Type mismatch. It should therefore be:
SELECT *
FROM mytable
WHERE date = #23/07/2013#
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With