Trying to sum numberic values in the footer of a continuous form
I have a continuous form, which is actually a sub-form on a main form, with a numeric field in the detail. Then in the footer I'm trying to sum those values.
The field name in the detail is a calculated number named txtAmount
Then in the footer I have:
=Sum([txtAmount])
Isn't working. Why?
Microsoft Access
Last Comment
Jeffrey Coachman
8/22/2022 - Mon
Scott McDaniel (EE MVE )
Try using the same formula in the Sum method as you're using for the Calculated Field.
SteveL13
ASKER
Isn't working. Here is the formula I have in the calculated field:
=[txtQuantity]*[txtRate]
When I copy/paste that into the control for the field in the footer I get just the value of the calculated field in the first record on the continuous form.