Getting the Total from a running total

[SkiNLaB]

I have a running total that runs thru and adds things up for me, it works great

but i need the TOTAL of that running total in my group footer, any ideas??

at the moment it just prints it as a normal running total, slowly building up like it should, but how would i use that final value in a formula used in a groupfooter, because at the moment it returns whatever the Running total is up 2 at that point of evaluation.

[SkiNLaB]

bah i have just heard that it is not possible. FECK

[ducky]

Use summaries on the field instead of a running total. This way you can have a formula at the group footer level that uses both the summary at that group point, and the overall summary total. This is how I do percentages that are broken out by groups.

[SkiNLaB]

i wish i could use a summary, but i use every feature of the running total like evaluate when this field changes, and reset on a certain condition. and i cant see how i could emulate that in a formula....

anyway i think i might be able to use SQL query expressions to get around this perhaps.