Rounding up 1

[Kingsteveiv]

Im trying to round values up using the CInt Function. However, this function rounds down if the value returned is below .5. I would like it to round up regardless of the decimal value returned.

Is there a function out there to do such a thing?

ex. 25/3 = 8.3333 ----> 9


thank you for any help!

 

[DotNetGnat]

use Round() function...

-DNG

 

[Kingsteveiv]

microsoft access does not have a round function...

 

[DotNetGnat]

take a look at these FAQ's

faq701-4298
faq701-3133

-DNG

 

[DotNetGnat]

and i think you can use Round() without any problem...

-DNG