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?
The field name in the detail is a calculated number named txtAmount
Then in the footer I have:
=Sum([txtAmount])
Isn't working. Why?
Scott McDaniel (EE MVE )
Try using the same formula in the Sum method as you're using for the Calculated Field.
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.
=[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.
Are you doing this in the Footer of the Subform?
ASKER
Yes.
Try with either:
=Sum([txtQuantity]*[txtRat
or:
=Sum([Quantity]*[Rate])
if Quantity and Rate are the names of the fields of the recordsource.
/gustav
=Sum([txtQuantity]*[txtRat
or:
=Sum([Quantity]*[Rate])
if Quantity and Rate are the names of the fields of the recordsource.
/gustav
ASKER
Neither worked.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All helped. Thanks.
You are welcome!
/gustav
/gustav
;-)