P: n/a

Hello,
I have a problem with logic of rounding function.
For examp.: the result of expression =[TaxableSum]*[TaxRate]
is 6,825 and when I use round on 2 decimal places I get 6,82 instead of
6,83!?
If I dont use round function, I can display 6,83 with field formating, but
then in next calculations I'm getting error because it calculates the number
6,825.
Please, help!
I am using Access 2003.  
Share this Question
P: n/a

On Mar 11, 7:01 am, "tom" <t...@tomdizajn.hrwrote:
Hello,
I have a problem with logic of rounding function.
For examp.: the result of expression =[TaxableSum]*[TaxRate]
is 6,825 and when I use round on 2 decimal places I get 6,82 instead of
6,83!?
If I dont use round function, I can display 6,83 with field formating, but
then in next calculations I'm getting error because it calculates the number
6,825.
Please, help!
I am using Access 2003.
http://groups.google.ca/group/comp.d...ess&q=rounding  
P: n/a

"Gord" <gd*@kingston.netwrote in
news:11*********************@q40g2000cwq.googlegro ups.com:
On Mar 11, 7:01 am, "tom" <t...@tomdizajn.hrwrote:
>Hello,
I have a problem with logic of rounding function. For examp.: the result of expression =[TaxableSum]*[TaxRate] is 6,825 and when I use round on 2 decimal places I get 6,82 instead of 6,83!? If I dont use round function, I can display 6,83 with field formating, but then in next calculations I'm getting error because it calculates the number 6,825.
Please, help!
I am using Access 2003.
Is 6.825 closer to 6.82 or 6.83?  
P: n/a

On Mar 11, 11:01 am, "tom" <t...@tomdizajn.hrwrote:
I have a problem with logic of rounding function.
For examp.: the result of expression =[TaxableSum]*[TaxRate]
is 6,825 and when I use round on 2decimalplaces I get 6,82 instead of
6,83!?
The ROUND() function uses banker's rouding algorithm. See: http://support.microsoft.com/kb/196652
Jamie.
  
P: n/a

It's in the middle, but I want to round up that value.
I have solve the problem with the Format and CDbl function.
Thank you Gord!
"lyle fairfield" <ly******@yahoo.cawrote in message
news:QG**************@read1.cgocable.net...
"Gord" <gd*@kingston.netwrote in
news:11*********************@q40g2000cwq.googlegro ups.com:
>On Mar 11, 7:01 am, "tom" <t...@tomdizajn.hrwrote:
>>Hello,
I have a problem with logic of rounding function. For examp.: the result of expression =[TaxableSum]*[TaxRate] is 6,825 and when I use round on 2 decimal places I get 6,82 instead of 6,83!? If I dont use round function, I can display 6,83 with field formating, but then in next calculations I'm getting error because it calculates the number 6,825.
Please, help!
I am using Access 2003.
Is 6.825 closer to 6.82 or 6.83?
  This discussion thread is closed Replies have been disabled for this discussion.   Question stats  viewed: 5159
 replies: 4
 date asked: Mar 11 '07
