asked on 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?
Microsoft Access
Last Comment
Jeffrey Coachman
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
All helped. Thanks.
You are welcome!
/gustav
/gustav
;-)