Rolling Totals in Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PS - 17 Jan 2006 20:41 GMT

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.

Reply to this Message

Rick B - 17 Jan 2006 20:52 GMT

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.

Signature

Rick B

> Hi,
>
[quoted text clipped - 3 lines]
> report.
> Please any help or direction would be greatly appreciated.

Reply to this Message

PS - 17 Jan 2006 21:02 GMT

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

> 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.
[quoted text clipped - 10 lines]
> > report.
> > Please any help or direction would be greatly appreciated.

Reply to this Message

Pat Hartman(MVP) - 17 Jan 2006 22:36 GMT

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.

> 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
[quoted text clipped - 22 lines]
>> > report.
>> > Please any help or direction would be greatly appreciated.

Reply to this Message

PS - 18 Jan 2006 14:05 GMT

I would have to use a VBA Code then correct?

> your criteria would be something like:
> Where Format(YourDate,"yyyymm") Between Format(DateAdd("yyyy", -1,
[quoted text clipped - 29 lines]
> >> > report.
> >> > Please any help or direction would be greatly appreciated.

Reply to this Message

Rick B - 18 Jan 2006 16:33 GMT

Or a filter in your report.

Signature

Rick B

>I would have to use a VBA Code then correct?
>
[quoted text clipped - 36 lines]
>> >> > report.
>> >> > Please any help or direction would be greatly appreciated.

Reply to this Message

Rick B - 18 Jan 2006 16:34 GMT

No, that would be the criteria in your query.

Signature

Rick B

>I would have to use a VBA Code then correct?
>
[quoted text clipped - 36 lines]
>> >> > report.
>> >> > Please any help or direction would be greatly appreciated.

Reply to this Message