Rounding Issues

[mattc66 via AccessMonster.com]

List Price: $153.05
x .70
= $107.135 Rounded to $107.14
Shipping: $10.00
= $117.14
Sales Tax: 6% = $7.028 Rounded to $7.03
The total should be: $124.17, however its is coming out as $124.16.

What can I do on my form to calculate the correct rouned amounts?

Thanks
Matt

 

[Piet Linden]

List Price: $153.05
x .70
= $107.135 Rounded to $107.14
Shipping: $10.00
= $117.14
Sales Tax: 6% = $7.028 Rounded to $7.03
The total should be: $124.17, however its is coming out as $124.16.

What can I do on my form to calculate the correct rouned amounts?

Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200906/1

I suppose you could do the old Multiply by some factor of 10, ROUND,
Divide... basically force it to round the way you want...

 

[Allen Browne]

Explicitly typecast (to currency) and round.

Your initial calcuation is:
Round(CCur(153.05 * .7), 2)
Your tax is:
Round(CCur((10 + 153.05 * .7) * .06), 2)

That will give you 107.14 + 7.03 = 114.17.

Most values will work without the CCur(), but you need it before rounding to
deal with odd cases to avoid floating point issues:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems

More info on rounding in Access:
http://allenbrowne.com/round.html