Roundind up!!

[Milan]

I need to able to round up if > then >0.5 or round down if <0.5
would appreciate your help here!!

Milan

 

[Mile-O]

I posted a solution to this on another thread

The syntax may be different whether you are doing it in a query or with variables in code, but the principal is the same.

 

[Dgar007]

CInt and CLng will round fractions.
x = 4.5
y = CInt(x)
y now = 4
x = 4.51
y = CInt(x)

y now = 5

Hope this helps