Rounding question

Hello,

I have created a report that calculates how many shipping pallets is needed
for a particular shipment. I need the result to always round up.
Currently, if the result is 1.1 it rounds to 1... But I need it to always
round up, in this case to 2.

Any suggestions on how to do this?

Many thanks!

Helen

The Int() function rounds down, so you can round up by negating the result,
using Int() and then negating again.

Try:
= - Int( - [your calculation here])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Helen" wrote in message
...

I have created a report that calculates how many shipping pallets is
needed
for a particular shipment. I need the result to always round up.
Currently, if the result is 1.1 it rounds to 1... But I need it to always
round up, in this case to 2.

Any suggestions on how to do this?

Many thanks!

Helen