calculating grand total from calculated control

[Miranda]

hi,

i've got a calculated control on my main report which adds up subtotals from
some subreports and gives a total value which is grouped by date. I want to
get the sum of totals for each day to get the grand total. can i simply say
= sum ([calculated_control_total] ??

 

[Wayne Morgan]

Place a 2nd textbox next to the current one. Set this new textbox's Visible
property to No. Place the same calculation in it that you have in the
current textbox. Set the new textbox's Running Sum Property to Over All. To
display this value, place a textbox in a footer section and set the Control
Source of this footer textbox to the hidden textbox.

=txtSummingTextbox