nycdon said:
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.
