How we wished Access had the roundup and rounddown functions like Excel!!

Seems we can have workarounds for this one too.

To roundup a calculated value or a field value to zero significance (in other words, the equivalent of ROUNDUP(num,0)) , just do the following

PHP Code:
SELECT CINT([NumberToRound]+0.5) FROM [MYTABLE] 
Similarly, to rounddown with zero significance,

PHP Code:
SELECT CINT([NumberToRound]-0.5) FROM [MYTABLE]