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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form Calculations Not Correct

Status
Not open for further replies.

mbiro

Programmer
Nov 20, 2001
304
I have a simple form that has a quantity, unit price, item total. The form calculates the item total by multiplying quantity and unit price. There is also a subtotal field that adds all the item totals together. There is a shipping field that multiplies the subtotal by .05. Finally, there is a total price field that adds the subtotal and the shipping together.

The problem is that the form seems to calculate the total price BEFORE it calculates the shipping. Therefore, the total price is wrong.

I am obviously doing something really stupid, but I can't see it. Suggestions?
 
They hid this feature, but can be fixed easily.

Go to Advanced Menu
Forms
Set Field Calculation Order.

Have a good weekend.
Samaba
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top