Rounding Up

M

Michael D. McGill

Is there a function in Access 2000 to round a number up to the next whole
number. For example:

2.1 needs to be rounded up to 3.
2.0 needs to stay a 2.

Basically anything with something other than 0 after the decimal needs to be
rounded up to the next whole number.

Thanks in advance,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up or down to nearest 5, but not 10 2
I need to always Round UP if greater than zero at all. HOW? 9
Rounding up .5 in a calculation 1
in access, round up to nearest fraction(.5) 1
Round Up a Decimal 6
DateDiff("yyyy",[Anniversary],Now()) returns rounded number 3
Rounding up to 2 decimals 4
Rounding Time? 4

Top