Question about using the Month function.

[Chelsea7]

Hello, I have a question about querying Month and Year. In the criteria, I want to query everything from let's say this month to previous months and year. I used this;

<=now()

This works but of course it's based on the current systems date. I need it to give me the entire current month. So if I query now it will only give me records 11/21/2010 and older. However, there are records with the Due_Date field 11/30/2010. I need to include this in the query. In other words the entire month and year to previous months. Is there anyway to do this without creating a field on a form?

If tried using Month(date()) but the result is the same as using Now().

I prefer to use the criteria section and not VBA. Any assistance will be appreciated.

 

[MajP]

The last day of the current month:
<=DateSerial(Year(Date()), Month(Date()) + 1, 0)

 

[Chelsea7]

That worked! Thanks a million.