group subtotals

A

access2003

I am working on a simple report based on a query that
groups and subtotals a club membership list by member
type (Life, Regular, Associate, ....). It works well
except the total for the last group is always the total
of all records. I have tried using count(field), count
(*) and even created a dummy field =1 and then used sum
(dummyfield) and it all gives the same results.
 
G

Guest

After further examination it seems the group totals are a
running total rather than a subtotal of each group.

I have not looked at the problem in that light but if
anyone has an idea I'd be happy to hear it as I won't get
back to this for a bit.
 
M

Marshall Barton

After further examination it seems the group totals are a
running total rather than a subtotal of each group.

I have not looked at the problem in that light but if
anyone has an idea I'd be happy to hear it as I won't get
back to this for a bit.
Click to expand...


The total text box in the group footer probably has its
RunningSum property to Over All or Over Group.
 
G

Guest

Yes, the RunningSum was set to OverGroup. Setting it to
No fixed the problem. I'll have to read up on that
setting.

Thank you very much for your help. You saved me a lot of
time.

Tom
 
Top