want to add sum fields in different sections of a report

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
 
K

Klatuu

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top