Sum Calculated Fields in Report Footer

G

Gwen H

I have a report whose group totals are calculated fields, not simply group
totals. How can I sum these group calculated fields in the report footer? I
have tried

=Sum([CalcFieldName])

....but it does not work in the report footer.
 
M

Marshall Barton

Gwen said:
I have a report whose group totals are calculated fields, not simply group
totals. How can I sum these group calculated fields in the report footer?
Click to expand...


Add another text box named txtRunTotal next to the
calculated text box. Set its control source expression to:
=nameofcalculatedtextbox
and set its RunningSUm property to Over All.

Then the report footer text box can display the grand total
by using the expression:
=txtRunTotal
 
Top