Rounding Numberic fractions to next whole number 2

[Dimonet]

When working within a report I want to output my result so that it rounds any fraction at all to the next whole number. For example:
.25 would round to 1
1.1 would round to 2
etc

Where would I specify this in the query/expression? Please advise.

Thanks,
Dimo

 

[THWatson]

Dimo
There may be other ways, but this is one...

In your query, enter an expression column
Int([YourNumberField]+1)

Tom

 

[PaulBricker]

The only issue I have with Tom's expression is if the value is already a whole number like 2. Then the expression rounds it to 3. You could use this expression to round up.
-1*Int(-1 *[NumberField])

This will do what you want.

Paul

 

[PaulBricker]

Another way to write this is
Abs(Int(-1 * [NumberField]))

That's probably a little neater expression.

Paul

 

[THWatson]

Oops. Paul is absolutely right. Sorry for that omission in my thinking.

Tom

 

[Dimonet]

Thank you all very much for your help!

 

[PaulBricker]

Bob Raskew pointed out to me that the expression
Abs(Int(-1 * [Number])
doesn't work with negative values so if you have any negative numbers you should use the original post
-1 * Int(-1 * [Number])

Sorry for the confusion. I claim a Senior moment.

Paul