I want to total a particular group

[Guest]

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

 

[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
..