I have an unbound control in my form that calculates the subtotal for items (quantity * price = subtotal) for an order #. I'm trying to make another unbound control that calculates the entire cost of that order# (sum of subtotal = grandtotal). Is it possible to have calculations on one unbound control be based on another unbound control? I have been trying to do it based by the "name" property of the control, but doesn't seem to work. It seems that I have to create another field in my table for subtotal. Hope my question makes sense. Thanks in advance for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Unbound Controls for Calculation
- Thread starter demax182
- Start date
matethreat
Technical User
You cannot perform calculations on calculated items. But, if you put the following formula in it should work.
= sum(quantity * price)
Aaron
Destiny Is Not The Chances We Take, But The Descisions We Make.
= sum(quantity * price)
Aaron
Destiny Is Not The Chances We Take, But The Descisions We Make.
- Status
Similar threads
- Locked
- Question
