Subtotal in a Group, and report footer

[SRussell]

I have a Count(status) in my query grouped on custID, Status. My detail
displays the Status description, and the count column. In the customer
group footer I want the total of all the status items within that group.

I have seen running total but that doesn't seem to do I want.

What am I missing here? I will also want to catch the total for the report
footer for a total count by status. In crystal this is pretty easy and I
guess I am just missing the how to in access.

Thanks!

 

[Al Camp]

S,
If your report is Grouped properly, and Status is a bound (non-calculated) field
then...
= Count(Status)
in any GROUP Footer would yield the count for that CustID only.
In the REPORT footer,
= Count(Status)
would yield the total Status count for all the CustIDs on the report.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.