Running Sum Over Group-doesn't work

  • Thread starter Thread starter SEA
  • Start date Start date
S

SEA

I have a report that has data for many days in months in
quarters. The user chooses the year and quarter, and the
report prints by Saturday week ending date (from the table
and query).
Sorting and Group has Month as the First Group, with a
footer (no header)

GroupFooter0 is the name of the footer. I want to total
by Month.

In the footer I have:
=sum([Field2])
and said in Properties
Over Group.

The problem is that the Sum isn't clearing out. I am
getting Over All results in the field, but I specified
Over Group.
Date Field1
2/7/04 7.61
2/14/04 12.33
FEB 19.94
3/6/04 0.00
3/13/04 1.17
MAR 21.11

MAR should be 1.17.
Another group has no values for 3/6 or 3/13, yet the total
from FEB carries down.

HELP!!
Thank you.
SEA
 
To calculate a sum in a group footer, don't mess with the Running Sum
properties. Leave it at "No".
 
Back
Top