Rounding UP - always

[N-Kaos]

I have one numeric field on a report that I want to always round to the
higher number and never the lower number. Setting the number of decimal
places to zero will not work for this. I have 2007 Access. Thanks.

 

[John Spencer]

One method if your number is always positive and you want to round to the
higher integer. Use an expression like

-Int(-[Your Number])

That will return
1 for 1
and
2 for 1.0000001 up to 1.99999999
etc.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[FBxiii]

I was told on here once to add 0.5 to the number, forcing it to round to the
higher number. e.g. 2 + 0.5 = 2.5, rounds up to 3.