Rounding UP - always

  • Thread starter Thread starter N-Kaos
  • Start date Start date
N

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.
 
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
 
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.
 
Back
Top