Round function

[Tracy]

Has anyone else noticed that the round function rounds up and then down in sequence?

So...
0.5 is rounded to 0
1.5 is rounded to 2
2.5 is rounded to 2
3.5 is rounded to 4
4.5 is rounded to 4

Is there a way to specify whether the number is rounded up or down? I can write my own function, but I am surprised that there is no obvious way of specifying this in the VBA function.

The help doesn't even bother to mention this.

Thanks
Tracy

 

[Tim K.]

Check this Access 2002 Rounding Function out.