summing textBoxes

[sturner333]

On a form I calculate the product of 2 numbers from a table and place them in
a corresponding textBox for that record on the form. The user can update
these 2 numbers or add a new record.I would like to sum the textBox's with
the products from each record in a textBox in the form footer but I
understand you can't do this.? How would I accomplish this task?
Thanks!

 

[Al Campagna]

For example... Price * Qty = LineTotal, and you want to add up all the
LineTotal amounts in the footer.
In the query behind your form, create a calculated "bound" field...
LineTotal : Price * Qty
Now place LineTotal on the form, and in the Form Footer an unbound
control with a ControlSource of...
=Sum(LineTotal)
will add up those values.
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[sturner333]

I fairly new at this but I have 2 questions:
How do specify a calculated "bound" field
If I tie my form to a query as opposed to a table, will the user be able to
add new records
Thanks much for the help!

 

[scubadiver]

You are getting into dodgy territory with calculated fields. They should
never be stored in tables.

What do you mean by this: "The user can update these 2 numbers or add a new
record" ???

 

[sturner333]

I don't store the calculated values. The 2 numbers I refer to are partCost
and partQuantity. I calculate the total part cost but mult these 2 fileds,
but I don't have them in a table.
Thanks

 

[Al Campagna]

Use the Query Design screen, bring in all the table fields you need...
and...
In a blank column, in the query rows....
Field: LineTotal : Price * Qty
Table: (there is no table)

This creates a calculated field "bound" (during the report) to the name
LineTotal.
Create a new text control with a ControlSource of LineTotal.
This LineTotal value/s will NOT be saved to the table, but will diplay
(when the report runs) the correct calculated value for LineTotal.
And... will allow adding up, in any Group or Report footer with
=Sum(LineTotal)
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."