Sum Calculated Fields in Report Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top