Rounding

[Les]

In a table or query, is there a way I can force it to
always round UP to the nearest whole number (1.1 would
round up to 2)?

 

[Jeff Boyce]

Les

First, I'd suggest a query for this, as changing 1.1 to 2 loses some
information.

One way to do this in a query would be to find the integer value, then add
one. Check on the CInt() function in Access HELP.

 

[Steve Schapel]

.... unless the value is already an integer ;-)

Could be something like...
RoundedUp: Int([MyField])+IIf([MyField]>Int([MyField]),1,0)

 

[Jeff Boyce]

Oops! Boundary conditions! Thanks, Steve!

Jeff Boyce
<Access MVP>

 

[Ken Snell]

Or, if it's always a positive integer:

Int(-TheNumber)

Or, to catch both positive and negative:

IIf(TheNumber>0, Int(-TheNumber), CInt(TheNumber))

 

[Steve Schapel]

Ken,

I could agree if you put another - in there...
-Int(-[TheNumber])

Man, I just gotta watch you and Jeff like a hawk! <g>

 

[Ken Snell]

A - here, a - there...... yep!

Thanks!

--

Ken Snell
<MS ACCESS MVP>

Ken,

I could agree if you put another - in there...
-Int(-[TheNumber])

Man, I just gotta watch you and Jeff like a hawk! <g>

--
Steve Schapel, Microsoft Access MVP

Or, if it's always a positive integer:

Int(-TheNumber)

Or, to catch both positive and negative:

IIf(TheNumber>0, Int(-TheNumber), CInt(TheNumber))