Rounding Tax Issues

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a rounding problem, it works at the check level but if you add all of
the sub together then apply the tax it's different. The tax is .0825...I'm
using Round(),2 on the fields.

Sub Tax
5.00 .41
6.50 .54
3.25 .27
6.50 .54
6.50 .54
6.50 .54
1.25 .10
1.25 .10
3.25 .27
40.00 3.31

but 40.00 * .0825 = 3.30

the higher sub becomes the more I lose on the tax calculation. Is there a
remedy for this?
Thanks
DS
 
Don't use round - just display the 1st 2 decimal places on a non-rounded
calculation. Then your final results will be correct
 
Sub Tax You show
5 0.4125 0.41
6.5 0.53625 0.54
3.25 0.268125 0.27
6.5 0.53625 0.54
6.5 0.53625 0.54
6.5 0.53625 0.54
1.25 0.103125 0.10
1.25 0.103125 0.10
3.25 0.268125 0.27
40 3.3 3.30

40 3.3 3.3

As you can see the tax and sums work out if you don't round the calculation

Good luck
 
Thanks Wayne, So in order to do this display I would do.....?
Format([TxtTax],"$#0.00") and put this in the place of the Round()
or is there another way?
Thanks
DS
 
If it were me I as just keep it simple as possible (always the best bet)

If you have a number of fields that want to perform calculations on then do
just that - unless there is a good reason not to. In this I can't see one -
mind I don't understand what it is you're trying to do, so I wouldn't see
anything ??.

eg.
If you just want to get the cumalative tax then do the calculation (add the
fields together "then" get the tax.

( ( (1 + 2 + 3+ 4) = 10 )* .0825 ) = 0.825

Even though you get the same answer I would not use
( (1*.0825)+(2*.0825)+(3*.0825)+(4*.0825) ) = 0.825
As - in some cirumstances - it has more chance of giving an error.

Even though you are doing this in access I think you may get a better answer
(about the maths) and why you may get a difference in cirtain circumstances
in the excel forum.

But for your access clculation - add the fields then do a 2nd calculation on
the result (you can do them in the same column / text box)
Thats what I do anyway - up to you

Good luck
 
Back
Top