MS access criteria for extracting all date values within the current month.?

H

Hawkins M

New member
I have a query which is supposed to Extract all the sales records within the current month. Under the "sale's date" field what criteria should I enter to make it work?

Note-Month() didn't work
Month(date()) didn't work
 
Back
Top