Access Round() Function Question

J

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
 
J

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
 
T

Terry

Hi Jai,

Add 1 to result of Int()

Regards


Jai_Friday said:
Thanks for the reply

However the Int() Function rounds down the number

example value 2.06 should be 3 but it returns 2

Jai
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top