want to add sum fields in different sections of a report

  • Thread starter Thread starter Repent
  • Start date Start date
R

Repent

I am using Access 2007

I have a report that is based on a query.

when the report is generated, it is setup to group, by TimeID, all the
records in the report. For example, all records with a TimeID of
6:30am are shown together first, then after that all records with
TimeID of 8:30am show up listed together, etc.

what I want to do now is to add a sum field for a few of the fields
after each group. For example, the field named "LF Run" and "LF
Produced" should be summed after each grouping so there would be
different summed groups on the report, each sum reflecting that group.

How can i do this? I tried looking at the grouping and sorting but
that didn't seem right.

thanks;
chris
 
Create a group footer and create textboxes that sum the field (not control).
Sum([LF Run ])
 
Back
Top