Sub Totals and Totals in a report

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

Guest

I have a field called Attendee, a field called event, and a payment amount
field for each event. I need a report that subtotals the payment amount by
the event and then totals the entire report.
Please help.
 
adding said:
I have a field called Attendee, a field called event, and a payment amount
field for each event. I need a report that subtotals the payment amount by
the event and then totals the entire report.
Click to expand...


Use Sorting and Grouping (VB editor View menu) to greate a
group with footer section. Add a text box to the group
footer and use the expression:
=Sum([Payment Amount])
do the same in the Report footer section.

If you prefer you can use the header sections instead of
footers.
 
Back
Top