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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subtotal in Query 3
Report 1
Getting most recent detail record for each master and associated fields 1
Sub total 1
Getting Text data using the Data - Subtotal feature 1
monthly subtotals and totals 1
Calculating subtotals 22
Basic Update Query 6

Back
Top