Roundup Function

[Guest]

Hello ,

I am trying to use a "Roundup" function in an Access report.
I have used this function in excel but it does not seem to be available in
Access.

i.e. 57 / 5 = 11.4 Roundup= 12

The "round" function in Access does not round up, any ideas that do not
involve VB?

Thanks,

Alan.

 

[John Spencer]

How about a little VB?

The following should work to round up positive numbers correctly.

-Int(-[YourNum])

-Int(-(57/5)) will return 12

_