query

[Paul]

I am trying to create a date query but am having troubles.

SELECT *
FROM Results
WHERE Test_Date Between '2/2/2006' And '12/1/2006';

When I run this query I get Data type mismatch.

The Test_Date field is set to Date/Time

I tried adding the time as shown in the database but I still got the same
error.

Thanks for any support.

 

[KARL DEWEY]

Try it like this --
WHERE Test_Date Between #2/2/2006# And #12/1/2006#;

 

[Paul]

Thank you very much.
Paul

Try it like this --
WHERE Test_Date Between #2/2/2006# And #12/1/2006#;