Running Sum Cummulative Total

[misscrf]

I have a group header with monthly amounts of stuff. Above that is a header for the whole collection of stuff that is being reported on by month. In the month grouping, I have a running sum of a calculated field. In the main group footer I need to create a cummulative total of that running sum.

So the running sum is txtrunningsum
Shows data like this:
$5.00
$28.00
$34.00
txtrunningsum is set to running sum over group.

In the footer I need a total that will give me the output of $67.00 but I can't seem to get that. I have tried a hidden field in the month group and then calling it from the main footer, but that doesn't work, if I call the visible field and try to sum it, The report asks for that field like a parameter.

Anyone know off hand what I need to do?

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[dhookom]

Have you considered creating a similar text box with a running sum Over All and then referencing its name in the control source of a text box in the report footer?

Duane
Hook'D on Access
MS Access MVP

 

[misscrf]

I tried that and many methods under the sun. I finally gave up and just manually calculated the right total and put it in the report so it looks like it is totalling. I won't have to repeat this on a regular basis (hopefully).

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[dhookom]

Your entire setup isn't clear. Generally running sums aren't needed or required since calculations can mostly be included in the Sum in a text box. For instance:

  =Sum([Quantity] * [UnitPrice] - [DiscountAmt])

The above expression would work in any Report or Group header or footer. [tt][blue]manually calculated the right total[/blue][/tt] shouldn't be necessary in most cases.

Duane
Hook'D on Access
MS Access MVP

 

[misscrf]

Thanks for responding again. I was told to go another direction on the report. I am researching that now and will make a new post if I have questions.

Thank you,

misscrf

It is never too late to become what you could have been ~ George Eliot