records in current month

[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

 

[Duane Hookom]

Set the criteria under the date field to:

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