Round up?

I am trying to roundup a calculation using the expression builder but can't find a command to handle this.

Fairly novice user using Expression Builder as opposed to SQL. Any help would be appreciated.

Have tried MROUND, and ROUND which are not recognized

Try Int() function

Corruptor,

Thanks for reply. Looks like INT() rounds down, I need to round up.

Any other ideas?

Thanks again

Since I don't know Access deeply I would say no, but...

It takes some time to solve it but it should work:

Create your own function something like this in Basic module:

Function RoundUp(ToRound as Single) as Integer
RoundUp=ToRound
end Function


This will work for sure, 'cause VBA will do the correct rounding for you.

Once you have defined this function you can use it anywhere you want.


Hope this helps.

SELECT ROUND(12.55,1);

result 12.6

SELECT ROUND(12.55,0);

result 13