chaverly
asked on
Using Datetimes in Access 2007 queries
I am used to SQL Server Management Studio and am transporting my SQL queries into Access 2007. How would I write this in Access?
SELECT Orders.[Order Date]
FROM Orders
WHERE
Orders.[Order Date] >= '01/01/2004 00:00:00' and
Orders.[Order Date] < '01/01/2005 00:00:00'
SELECT Orders.[Order Date]
FROM Orders
WHERE
Orders.[Order Date] >= '01/01/2004 00:00:00' and
Orders.[Order Date] < '01/01/2005 00:00:00'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.