By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Rounding numbers

P: n/a
tom
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.
Mar 11 '07 #1
Share this Question
Share on Google+
4 Replies


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

Mar 11 '07 #2

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?
Mar 11 '07 #3

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.

--
Mar 12 '07 #4

P: n/a
tom
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?

Mar 13 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.