Rounding Up Numbers

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I'm running a query on actual weights for packages that we
have shipped. This is normally a 2 decimal number.
(Example: 2.24 lbs.) In my query or report, I need this
numbet to always round up which is the way the US. Post
Office or UPS calculates shipping rates. Is there anything
simple that I can do/use?? Thanks!
 
Chris

Tom wants to round the number UP all the time so your suggestion won't work
correctly.
 
Tom,
the Int() function will always round negative numbers away from 0. For example:

Int(-3.1) = -4
Int(-2.9) = -3

You can use this to your advantage and try something like:

-1*(Int(-1*myVariable))

assuming that your value is always a positive number

Best regards,
R/mi.
 
Back
Top