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

Calculating fields in a form

Status
Not open for further replies.

JonR

Technical User
Feb 21, 2001
22
US
Please help!

I created an order form at
The fields that calculate are under the Quantity, Price and Total columns. They are set to "No Contstraints." I want to make the Price and Total fields fixed decimals (2 decimal places) because when I try the following examples I get incorrect calculations...

3 X 15 = 0.44999999999999995

3 X .35 = 1.0499999999999998

3 X .55 = 1.6500000000000001

3 X .65 = 1.9500000000000001

3 X .95 = 2.8499999999999996

Has anyone experienced this before? I'd love to be able to show that 3 X .15 = .45, etc...but cannot at this time.

Any help or insight would be much appreciated.

Thanks,

Jon
 
You will need javascript to accomplish this. I have a script but it works in conjunction with too many other things to try and break down. Ask the Javascript forum, they will be great help. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top