Summing a group of a group

[Suncoast]

I have a report that has a group within a group. The interior group has a footer with a textbox calculating an average. I would like the Outer group to then SUM the averages. I tried doing a =sum([TextBoxWithTheGroup Average]), but access prompts me for the value of this box when I run the report.

To summarize: is there a way to sum a textbox within the footer of a grouping

 

[rzw0wr]

Set the outer group text box to Running Total and bind it to the text box you want to have the running total on.

Dale