Report grouped totals not resetting.

[Theresa]

Hi,
I have an access report based on a query that produces three items of data:
Airframe - either "Powered Aircraft" or "Rotary"
Aircraft = the tpye of aircraft in text format
CountOfID = numerical value
I have grouped the report as follows:
Airframe - with header / footer
Aircraft - no header/footer
I placed the following code into the Airframe footer with running sum over
group:
Sum([CountOfID)]
The idea is to print a Airframe heading, followed by a list of 'Aircrafts'
and their associated counts (counts created by the underlying query not the
report) and then sum over the Airframe. So at the end there is a tally for
each Airframe.
When I run the report the first value of 'Airrame' tallies correctly but the
second value of 'Airframe' simply continues to add the next group of counts
to the first group. In other words the Sum function is not resetting after
the first instance of 'Airframe'.
How do I force it to reset?

 

[Duane Hookom]

Try turn off the running sum.

 

[Theresa]

Try turn off the running sum.

--
Duane Hookom
Microsoft Access MVP

Thanks it worked.