Date Criteria

M

mjohearn

I would like a query that reports all forecast dates for the current month,
along with all forecast dates from the previous and following month. E.g.,
for the month of March, I want a report on February, March and April. I know
how to request the months specifically, but I would like something generic so
I don't have to change the dates in the query criteria field every month. As
I have it set up now, I only get a report that gives me forecast dates 30
days plus and 30 days minus the current date. I'm using the following syntax:

Between Date( ) And DateAdd("M", 1, Date( )) OR
Between Date( ) And DateAdd("M", -1, Date( ))

I would use...

Year([ForecastDate]) = Year(Now( )) And Month ([ForecastDate]) = Month(Now( ))

....but this only gives me the current month, and I don't know how to work it
to give me next month and last month's dates.

Is there a way that I can get all of the current month, previous month and
following month in one report?
 
Top