Link to home
Start Free TrialLog in
Avatar of chaverly
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'
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial