Previous Month in query

P

programmingrookie

I have a date field "reportdate" set to a short date format. I want to pull
the month and year of the previous month as a criteria for a query. For
instance, for January 2008, I want to pull all records from December 2007.
Any ideas would be greatly appreciated.
 
K

KARL DEWEY

In design view add a calculated field like this ---
Report_Month: Format([YourDateField], "yyyymm")

In criteria for the field use ---
Format(DateAdd("m", -1, Date()), "yyyymm")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query last day of previous month 1
Query for previous week, Sun thru Sat, from date field 1
Filtering query by month and year 6
Previous Month Query 5
all dates with month greater than equal current month 3
Excel Vba to change displayed year automatically. 14
Crosstab Query & Month Names 3
Setting a Month Criteria 9

Top