Round function

[Suresh]

The round function does not round the value 00.50
In maths round function should round values from .50 and
above.
If there is another function or another way of rounding
please let me know.

Thank you.

 

[Allen Browne]

Floating point maths is always imprecise.

If you want that kind of precision, you will need to use scaled integers
instead. There is a custom rounding function in this link that converts the
value to a Variant of subtype Decimal so it can perform the scaled integer
math:
http://www.mvps.org/access/modules/mdl0054.htm