[AccessD] Unusual Sub Totals Needed on Access 2007 Report

All,

I am working on a report that has a need for rather unusual sub-totaling.

I will use a simple test example to explain what I am trying to do.

The data for the report comes from a query with only two fields “Group” and “Amount”.

There are three groups, Group-1, Group-2, Group-3.

The report needs to have sub-totals for each Group.  This is easy.

Now the tricky part.  The report also needs a total for Group-2 and Group-3 added together.   

Is there an easy way to do this?

Is there some way to capture select sub-totals for later use?  If I can capture the amounts, I can build the extra sub-total into one of the footers.

Thanks,
Brad