Criteria for a monthly sale

[xtrareal22]

I have a daily sales query.The criteria for date of sale is=Date() to show the sales for that day.I want another query to show the sales for that month.


So if all the sales took on december,i want the monthly query to display all the sales that took place for that month only.What do i do?what will my criteria be?

[June7]

Try:

SELECT * FROM tablename WHERE Format([date of sale],"YYYYMM") = [enter YYYYMM];

[xtrareal22]

thank you