Rolling Totals in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can someone tell me how I would create a rolling total in a report. Rolling
Total mean whenver one month ends the oldest month drops off of the report.
Please any help or direction would be greatly appreciated.
 
Running "total"? If you want to only include the current month on a report,
then do so by limiting the records selected for the report in your query.
The report total will total whatever is on the report. If you have only the
current month, then the total will only reflect the current month.

Please give us a specific example if this is not accurate.
 
When I run the report I would like to show the must current 12 months for
example at the end of this month I would like to show a report for the last
12 months meaning form Jan 05 to Jan 06, and next month for Feb 05 to Feb 06
and so on. Do you know if there is a way that I can show this automatically
without me having to manually go in and put in the dates? Thanks for your
prompt response
 
your criteria would be something like:
Where Format(YourDate,"yyyymm") Between Format(DateAdd("yyyy", -1,
Date()),"yyyymm") and Format(Date(), "yyyymm");

The functions extract the year and month from your date and compare it to
this month a year ago and the current month.
 
I would have to use a VBA Code then correct?

Pat Hartman(MVP) said:
your criteria would be something like:
Where Format(YourDate,"yyyymm") Between Format(DateAdd("yyyy", -1,
Date()),"yyyymm") and Format(Date(), "yyyymm");

The functions extract the year and month from your date and compare it to
this month a year ago and the current month.
Click to expand...
 
Back
Top