Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subtotal of several group totals, but not all

Status
Not open for further replies.

ajaeger

Technical User
Feb 6, 2003
201
US
I have a report that is grouped - let's say there are 5 groups: A, B, C, D and E. For each group, in the group footer, I have a sum of the AMOUNT field. In group footer C, I need to get a sum of all the AMOUNTs so far - in other words, I need to sum the subtotals in group A, B and C. I'm not sure how to do this.

Any direction would be great! Thanks.

Anna Jaeger
iMIS Database Support
 
You can add a text box in the group footers.
Name: txtRunSumAmt
Control Source: =Sum([Amount])
Running Sum: Over All
If you only want to display this in the "C" group footer, add code to the On Format event of the group footer:
Code:
Me.txtRunSumAmt.Visible = (Me.[txtGroupField] = "C")

Duane MS Access MVP
Now help me support United Cerebral Palsy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top