H

=ROUND(0.000004+1,5)
returns 1.00000
=ROUND(0.000005+1,5)
returns 1.00001

PS! There is same function in Access too, but Access uses 'Bankes rounding'
algorithm.


Arvi Laanemets


"R Marko" wrote in message
...
I've been programming Access for 10 years and am embarrased to ask this
question, but here goes. I'm using a template and am making minor
adjustments. I've never heard of rounding, What is the difference
between:

=ROUND(SUM(AB29:AB36),5)

and

SUM(AB29:AB36)

Rhonda