Text Box in group footer

[gmit]

Is is possible to refer to a text box in the group footer part of a report by name. The text box is named Total and shows a total for each weight in a group.
There's five groups so the text box is duplicated five times when the report is run, all showing a different weight total on the report. I want to be able to refer to the total in all the groups seperatley, any ideas anyone?

 

[Pat Hartman]

Access does not have any reason to keep group information available for each group break in the report. So, no you cannot obtain anything except the most recent value.

What are you trying to do? If you want to sum the group, just add a control to the report footer.

=Sum(YourField)

It should look exactly like the expression in the group footer. In fact you can copy and paste.