Have you tried using the Round function? It takes two parameters, the value
and the number of decimals places to round to. The default is zero decimal
places (an integer).
This response is supplied "as is" without any representations or warranties.
I need to round numbers in Access to the nearest integer, where I'd round up
if .5 or greater else round down. For example, need to round 33.5 to 34 and
33.2 to 33. I do not want to simply change the properties of the field...I
want the actual rounded number to populate the cell. Thanks!