Sub-Totals

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

Guest

Hi, Im trying to do a Report and I would like Sub-Totals of the amounts grouped by the primary key does any one know how I can do this?
 
Create a Group Footer and use the Sum operator, if the amounts are in the
field, and not calculated (Sum doesn't work on values that you calculate in
the report itself).

The Control Source for the Text Box in the Group Footer would be something
like:

= Sum([yourfieldsname])

Access Reporting is smart enough to figure out that Sums in a Group Footer
apply to records in that Group. You can use the identical Control Source in
the Report Footer, and it'll be smart enough to sum all the Records in the
Report.

Larry Linson
Microsoft Access MVP

Kath said:
Hi, Im trying to do a Report and I would like Sub-Totals of the amounts
Click to expand...
grouped by the primary key does any one know how I can do this?
 
Back
Top