Sub Total

[vikram_singh]

have a simple query that uses 3 fields. Location, Person and Value.
When I
group by location and person and sum value, I get all the results I
need but
I would love to see subtotals for each location. I'm using Access
2003. How
do I add in the subtotals. Something like

Maryland, Person1, 5
Maryland, Person2, 10
Maryland Subtotal, 15, - this is the line I'm trying to get
New York, Person 1, 20

Thanks in Advance,
Vikram

 

[S.Clark]

Queries aren't designed to weave in subtotals. So, you'll have to get
creative with mulitple queries, maybe writing the data to a temp table. My
suggestion would be to create a report based on the query, which will easily
allow you to display this information.