Sub Total

  • Thread starter Thread starter vikram_singh
  • Start date Start date
V

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
 
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.
 
Back
Top