I want to total a particular group

S

Suby

Folks,

I have a report based on outlets turnover. Records are grouped according to
outlets. There may be multiple outlets whose total should be calculated. I
tried running sum, but I am looking individual group sum not cumulative
(running sum). Any idea
 
J

John Spencer

Add the group footer and use a control in the footer with its source set to

=Sum([some field])

Make sure the control does NOT have the same name as any field in your
report.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Similar Threads

Dumb question alert! What program to use? 0
Group summation not working 3
Stop running sum(Over All) when customer change 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Running total by group 1
How to "copy" group running total to report footer? 3
total the subtotals 1
Chart with cumulative total 0

Top