Total Values

P

Public

Hi,
I am designing a report where I am grouping and then subgrouping by two
fields. What I want is to make totals at each grouping level (i.e. the main
group and subgroup levels).

Any ideas?
 
P

Public

I am using Access 2003. I went to View->Sorting and Groups but there was
nothing to control the totals.
 
J

John Spencer

Assuming that you added group footers, you can add controls to the footers
with sources like

Control Source: =SUM(Amount)

That should sum the amount over the relevant group. You can use the same
formula in a subgroup to get the sum for the subgroup.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
R

Rui

Sorry, After re-reading my post i realised I didn't explay properly.

John's explanation is much better than mine
 

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

Sort on 2nd group, not first 5
Calculate percentages for groups and subgroups 1
page totals 2
count groups, not records in a group 1
count of totals 1
Help with SUMIF & AND function 2
Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub 0
horizontal grouping in ACCESS reports 2

Top