I want to total a particular group

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

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
 
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
..
 
Back
Top