How do you round UP numbers

[Joe]

Hi all,

How do I take a simple number with decimals and round it
UP to the nearest whole number? I.E. '6.7' should round
to '7'. Similarly, '6.3' should ALSO round to '7'.

I am well aware of the functions Excel has, but I need
this to be done in Access 2000. Is it possible?

Thanks for your help!
Joe

 

[Ken Snell [MVP]]

For positive numbers:

RoundedUpValue = -Int(-MyValue)