Sum a footer

G

Gary

Hi, I have footer1 and footer2 in my report. In footer1 I perform a
calculation and use it at the footer1 level. I need to sum this text box that
hold the result of the calsulation in footer2. I have tried =sum(textbox) but
to no avail.
Any suggestions woudl be appreciated.

Thanks
 
I

ihatepaperwork

Try putting another text box (textbox2) in footer1 whose control source is
the first text box. Then change textbox2's running sum value to Over All. In
footer2, change the control source to =[textbox2].
 
Top