Summing Group Header Info

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

Guest

There may be a simple answer to this but I just can't figure it out. I want
to add up data that appears in, and is specific to, the group header of a
report without it multiplying it by the number of records in the detail
section.

e.g a report shows 5 meetings and the details of attendees at each meeting.
I have grouped by meeting with meeting details and budget figure in the group
header and the attendee information in the detail section. At the end of the
report I want to add up the 5 budget figures that appear in the header but
using sum([budgetfigure]) sums a budget figure for every attendee at each
meeting. How can I avoid this happening ? Thanks Mark
 
I think you have the BudgetFigure text box in the group header section
already?

Add another text box to the group header, and set these properties:
Control Source BudgetFigure
Running Sum Over All
Name txtBudgetFigureRS
Format Currency
Visible No

Now add a text box to the Report Footer section, and set:
Contorl Source =[txtBudgetFigureRS]
Format Currency

The running-sum text box will increment by the amount each time the group
header is prepared, so Access develops the total. At the end of the report,
the final text box reads the total from the invisible text box.
 
Back
Top