Total Values

[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?

 

[Rui]

the "sorting and grouping" button has options for that!

Cheers
Rui

 

[Public]

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

 

[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

 

[Rui]

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

John's explanation is much better than mine

 

[Public]

Thanks to both of you.