Help with current 12 month span

  • Thread starter Thread starter Pam
  • Start date Start date
P

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.
 
Assuming your record is time-tagged, use the following selection criteria on it:
Now()-366
Click to expand...
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...
 
Back
Top