Pulling data in current month

  • Thread starter Thread starter Dave Q
  • Start date Start date
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
 
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")
 
Back
Top