Pulling data in current month

D

Dave Q

Is there a way to set up a query to pull only information
in the current month? I have not been able to come up
with anything. I have a colum for the date in the short
date format in my table.


Thanks
 
F

fredg

Is there a way to set up a query to pull only information
in the current month? I have not been able to come up
with anything. I have a colum for the date in the short
date format in my table.


Thanks
Click to expand...

Add a new column to the query.
Exp:Format([DateField],"mm")
As Criteria for this column, write
Format(Date(),"mm")

The above is NOT year specific, so if your table contains records for
more than one year, you will get February records for February of each
year.

If you wish to restrict the data to the current year as well,
Exp:Format([DateField],"mm yyyy")
Criteria
Format(Date(),"mm yyyy")
 
Top