Stephen,
Still not quite sure what you looking for. Perhaps if you showed some
sample data, and the result you want to see, that might make it clearer.
You wrote...Then, probably you don't want a Running Sum, but a regular Sum of some
control value on the report... every time a Category "breaks."
For example, let's say you're adding... [SomeNumber], and [SomeNumber] is
not a calculated value.
With...
= Sum([SomeNumber])
in the CATEGORY Footer, you would get a total for EACH category.
With...
= Sum([SomeNumber])
in the REPORT Footer, you would get the sum over the WHOLE report. (all
Categories)
My running sum is in my Detail section because my report is grouped by
Category. So when I add it to the report footer it sums all of the
[quoted text clipped - 17 lines]