Avatar of SteveL13
SteveL13
Flag 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?
Microsoft Access

Avatar of undefined
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.
Scott McDaniel (EE MVE )

Are you doing this in the Footer of the Subform?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SteveL13

ASKER
Yes.
Gustav Brock

Try with either:

    =Sum([txtQuantity]*[txtRate])

or:

    =Sum([Quantity]*[Rate])

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

/gustav
SteveL13

ASKER
Neither worked.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Scott McDaniel (EE MVE )

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Gustav Brock

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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SteveL13

ASKER
All helped.  Thanks.
Gustav Brock

You are welcome!

/gustav
Jeffrey Coachman

;-)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes