424,985 Members | 1,861 Online
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 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
4 Replies

 P: n/a On Mar 11, 7:01 am, "tom"

 P: n/a "Gord" 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 insteadof 6,83!?If I dont use round function, I can display 6,83 with fieldformating, but then in next calculations I'm getting error because itcalculates 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"

 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" On Mar 11, 7:01 am, "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 insteadof 6,83!?If I dont use round function, I can display 6,83 with fieldformating, but then in next calculations I'm getting error because itcalculates 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.