Sum a Group

  • Thread starter Thread starter David Whitaker
  • Start date Start date
D

David Whitaker

Hey
Ive hit a snag.
How do you sum groups in a report - not a running sum -
I created a report and I did get the groups to work like I want but I am
trying to sum only each group.
I put a text box in the group footer and set the control source to the
appropiate field, I tried to set its running sum to "over group", but it
does the same as "over all".
What the over group does, it takes a running sum from each group and
combines them, what I am looking for is only each group not combined with
the others. Like

T020 group header section
10 20 30 detail section
15 15 15
total 25 35 45 group footer section
T021
20 20 30
15 25 14
total 35 45 44
 
Never mind - stupid me finally fiqured it out.
Isnt it funny how sometimes the most simplest things we make difficult.
 
All you should need is a text box with a control source like:
=Sum([MyNumericField])
No Running Sum.
 
Back
Top