Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
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?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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
Is the Calculated Field in the Query? You might try doing your calculation there, and then SUM the field from the Query.
Then, I guess, the footer is on the main form. If so, you will have to refer to the controls on the subform.
/gustav
/gustav
You never clearly states what "Footer" you were referring to...
In any event, ...You cannot sum a "Control" (txtAmount)
...you must sum the "Field" (Amount)
So as Scott suggests, ...make the calculation a field in the query, then you can sum it pretty much wherever you like.
simple sample attached
JeffCoachman
Database80.mdb
In any event, ...You cannot sum a "Control" (txtAmount)
...you must sum the "Field" (Amount)
So as Scott suggests, ...make the calculation a field in the query, then you can sum it pretty much wherever you like.
simple sample attachedJeffCoachman
Database80.mdb
Premium Content
You need an Expert Office subscription to comment.Start Free Trial