Current Month Query (Access 2003)

Topic

New Reply

I need to make reports based on dates: Current, Last Month, 3 Months , Year to Date.

I search and found most of the answers except for the Current month.

I was looking at this post:
Comparing records for last two months (2003)
post 700,889

I could not get it to work with the Min and Max functions so I will just ask.

If I have a table with Dates on it (in Date Format) How can I report on all records with the Current month only?

Thanks

Reply | Quote

Replies

(Edited by mbarron on 06-Aug-08 14:26. Screenshot was not correct)

You can filter on both the month and year where Year([DateField]) = Year(Now()) and Month([DateField]=Month(Now())

Reply | Quote

Thnk you very much…
That worked!!!!

Reply | Quote