Sum in report footer of calculated field in sub-page footer

[Shaun3]

Hi all, I am having sum problems with my report. Apologies in advance for my ineptitude w/ access.

I am looking at a report with a detail section, a subfooter (named EMPID footer), a page footer, and then the report footer.

In the EMPID footer, there is a textbox (named PSHIPTTL) with a calculated value based on other textboxes in that same footer.

I would like to sum all the values in PSHIPTTL in the report footer in a textbox titled GTTL. When I put =sum([PSHIPTTL]) in GTTL and run the report, it asks the user to input GTTL. If I just hit enter, it runs the report but my footer sum does not show up in the box.

Thanks in advance for any and all help!

 

[Shaun3]

OK just sorted it out; I used a calculated field in the report footer instead of summing all the calculated fields in the EMPID footer.