Aha! That makes it more complicated, but you can still do stuff like
=Sum(([Cost] + [Tax]) * [Quantity])
However, if it's getting to that point, you're probably better off to do as
much of the calculation as you can in a query that then supports the
report.. If you have a calculated field in a query that looks something
like Extension:([Cost] + [Tax]) * [Quantity]) you can then have a text box
for the Exetnsion field in your Detail section, and then a summary textbox
that uses =Sum([Extension]) in the appropriate footer(s).
"DS" <bo******@optonline.net> wrote in message
news:OO***************@fe08.lga...
Dave M wrote:
You have to sum the calculation rather than refer to the name of the
calculated control (presumably a text box). So if your Detail section
contains a text box named "txtTotal" and that text box's Control Source
is "=[Price] * [Quantity]" then your sum has to be in a text box with the
Control Source "=Sum([Price] * [Quantity])" rather than
"=Sum([txtTotal])
"DS" <bo******@optonline.net> wrote in message
news:7i*************@fe08.lga...
How do you get a sumon a calculated field in a detail section on a
report? I have a group footer that I need the sum on.
Thanks
DS
PS That calculated control is based on another calculated control.
DS