Date field

[AnnNguyen]

I have trouble in running this simple query:

SELECT * FROM Purchases WHERE Date Between #07/01/03# And #07/31/03#

I have this SQL statement in Access2000
Is there anyone can have a solution to a field named Date. I can't modify the field name as it is in a MYOB back end database.

Much appreciated!
Ann Nguyen

[Prasanna]

I tried your query on the same version of access.

It works fine.

Could you check it by putting the date in paranthesis, since it's a key word.

SELECT * FROM Purchases WHERE [Date] Between #07/01/03# And #07/31/03#

Regards,
Prasanna.

[AnnNguyen]

Thank you Prasanna,
I have solved my problem. My database links to MYOB back end database, therefore, date format likes this: '2003-07-01'.
Cheers
Ann Nguyen