Group totals

  • Thread starter Thread starter misc
  • Start date Start date
M

misc

I have ran a report and gathered totals for each group in a report.

eg.


adult 5
child 7
Senior 22


I now wish to place these totals in the report footer, eg

Adult = 5, child = 7, senior = 22

How do I do this?
How can i give an unbound text box the adult, child or senior value?
 
I would probably create a totals query and use it in a multiple column
subreport to place in the report footer. This would easily allow more
"groups" without coding or modifying designs.

Another, less maintainable method is to add three text boxes:
=Sum( Abs([YourField]="Adult"))
=Sum( Abs([YourField]="Child"))
=Sum( Abs([YourField]="Senior"))
 
Back
Top