how do I total a series of numbers in a report

[amelia]

I am trying to total serveral columns and then put their
totals at the bottom of the report. For example, I want
all the numbers in the Total Revene column to be added and
then totalled at the bottom underneath the column. Does
anyone know how to do this? Thanks very much!
Amelia

 

[Duane Hookom]

Add a text box to the REPORT footer (not PAGE) with a control source of:
=Sum([TotalRevenue])
If Total Revenue is a calculated value in the detail section, you will need
to use the expression of the calculation:
=Sum([Revenue]-[Expenses])