Display a list of group subtotals in the report footer?

[TudorSmith]

Does anyone know how to do this?

I have an access report, with two specific groups (Possession & Resourcetype). For each group footer, I have a total value which is all good and well. In the PAGE FOOTER section though, the user has asked me to display all the running totals together for each group.

Lets say I have three groups in my possession (Week 47, Week 51 & Week 52). As the report runs I'll get a total for each group! In the page footer I'd like it to show:

GRAND TOTALS:
Week 47: £xxx.xx
Week 51: £xxx.xx
Week 52: £xxx.xx

Do I need to do this in the VBA code behind the report and store the total in a global variable...or can ACCESS be configured to capture the sub total and display it accordingly in the footer!

Any suggestions most welcome

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

 

[brettatexplace]

You could use a simple subreport that sums only what you want and add it on the page and/or report footers. This would give you totals on every page independent of whatever else is being display above.