Round function

  • Thread starter Thread starter Suresh
  • Start date Start date
S

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