Query to show results for current month only? 1

[mrtauntaun]

I have a query which returns a number of results, one of which a date/time field displaying mm/dd/yyyy hh:mm:ss AM/PM
example, 12/22/2005 5:23:32 PM
How can I set criteria for this query to show all records from the current month only?

 

[PHV]

SELECT ...
FROM ...
WHERE Format([date/time field],'yyyymm')=Format(Now(),'yyyymm')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrtauntaun]

Thank you very much for your prompt response, that did the trick!