subform calc

[Guest]

I have a calc for each returned subform row (continuos form)..can i sum these
calc'd fields? I get an error summing the text box in the subform's footer..
Thanks!

 

[Marshall Barton]

I have a calc for each returned subform row (continuos form)..can i sum these
calc'd fields? I get an error summing the text box in the subform's footer..

The Sum function should be in a text box in the subform's
header/footer section. It must refer to one or more fields
in the subform's record source table query (not other
controls on a form). For example if the calculated text box
in the detail section has an expression such as:
=Price * Quantity
then the total text box in the header/footer must use the
expression:
=Sum(Price * Quantity)

It may(?) be better to do the calculation in the (sub)form's
record source query.

 

[Guest]

Thanks Marsh! Was able to put the calc into the subforms' rec source query,
and bound the text box and summed successfully.