Do this in a report.

In report design view, open the Sorting And Grouping box (View menu.)
Choose the Location field, and in the lower pane of the dialog, set Group
Footer to Yes.

You can now add a subtotal to the group footer section.
The Control Source will be something like this:
=Sum([SumOfValue])

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"scott" wrote in message
...
I 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, Person 1, 5
Maryland, Person 2, 10
Maryland Subtotal, 15, - this is the line I'm trying to get
New York, Person 1, 20