-
Date field
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
-
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.
-
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