Query for current month

[RJL1]

I have a query data gathers daily statistics. I would like to query for just the current months data. The field name is date and is formated mm/dd/yyyy (9/3/2002). How can I sorth this data for the current month when I run my report.

Thanks
RJL1

 

[tsumrall]

Format your date as "mm yyyy" and set it's critera to format(Now(), "mm yyyy&quot

 

[RobPotts]

In the query add:

=Between [Enter Beginning Date] and [Enter Ending Date]

to the date field you want to filter on. This will then request the date range you want to look at.

You could also try something like
=Between Now() and DateAdd("m",-1,Now())

Which I think would look back one month from the date you open the query.

Hope this helps
Rob!

 

[RJL1]

I like the range option better. Just in case they want to see more that one month.

Thanks
RJL1