Sub Totals and Totals in a report

[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.

 

[Marshall Barton]

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.

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.