Access Round() Function Question

[Jai_Friday]

Morning everyone,

I have (hopefully) a quick query regarding using the Round() Function in a
query

I need to be able to round any value up to the nearest whole number , where
as the standard round funtion round up or down dependent on the closest whole
number.

So can you force it round up always?

Kindest Regards

Jai

 

[Jai_Friday]

Thanks for the reply

However the Int() Function rounds down the number

example value 2.06 should be 3 but it returns 2

Jai

 

[Van T. Dinh]

Did you use the 2 negative signs as I posted???

 

[Terry]

Hi Jai,

Add 1 to result of Int()

Regards

Thanks for the reply

However the Int() Function rounds down the number

example value 2.06 should be 3 but it returns 2

Jai

 

[Jai_Friday]

That sorted it , those 2 negatives god blee em

Thanks once again

 

[Van T. Dinh]

I think you would get an incorrect result if the input is a whole number.