Help with current 12 month span

[Pam]

Thanks in advance,

I have a subreport for a monthly mailing to suppliers that
shows 12 months of their perfomance. My questions is
regarding criteria for the query that is used. I need the
information that shows on the report to only report on the
last 12 months of performance, eventhough the table may
contain 3 years of data.

 

[Dennis W. Bulgrien]

Assuming your record is time-tagged, use the following selection criteria on it:

Now()-366

Now() is the computer's current date, which must be correct.
366 days is one more than the number of days in a year to include today one year
ago.


....I need the
information that shows on the report to only report on the
last 12 months of performance...