Help with between dates and times needed
by le456 - 9/6/12 4:50 AM
I have a query that I want to show only records with a datestamp between yesterday at 3pm and today at 3pm
I dont want to use a set date as I want to run this query automatically daily and email out the results.
My field is called MyDateVar and is formatted dd/mm/yyyy hh:mm:ss
(I'm using access 2003 - vintage i know!)
This is my sql so far - i'm not sure how to word the where clause:
SELECT tblMovLog.Field1 AS MyDateVAR, tblMovLog.Field2 AS [User], tblMovLog.Field3 AS Reg, tblMovLog.Field4 AS Logistics, tblMovLog.Field5 AS Dealer, tblMovLog.Field6 AS SaleType
ORDER BY tblMovLog.Field1 DESC;
Thank you for any help
le456 has chosen the best answer to his/her question.
Click here to view the answer that was selected.