how do I total a series of numbers in a report

  • Thread starter Thread starter amelia
  • Start date Start date
A

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
 
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])
 
Back
Top