records in current month

A

alecgreen

Hi

I want to use a query that returns records in the current month from a
date field, but cant work the query out - anyone help please

Thanks

Alec
 
D

Duane Hookom

Set the criteria under the date field to:

Between Date()-Day(Date())+1 AND DateSerial(Year(Date()),Month(Date())+1,0)
 
Top