Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

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?
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Try using the same formula in the Sum method as you're using for the Calculated Field.
Avatar of 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.
Are you doing this in the Footer of the Subform?
Yes.
Try with either:

    =Sum([txtQuantity]*[txtRate])

or:

    =Sum([Quantity]*[Rate])

if Quantity and Rate are the names of the fields of the recordsource.

/gustav
Neither worked.
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
All helped.  Thanks.
You are welcome!

/gustav