T
Ted
I am having a problem with rounding in Access 2000 VBA. I
have read the problems on here with floating point, and
even after trying the tips here I still have the problem.
Here is the formula in VBA:
Var1 = Round(1.25 * Var2, 2)
The value of Var2 is '.5'. After rounding, the result of
this should be '.63', and it keeps coming out to '.62' no
matter what I do. Var2 is defined as currency; I
originally defined as single. Same with Var2 -- Var2 is
also defined as currency; I originally defined as single.
What does it insist on rounding down when it should round
up?
have read the problems on here with floating point, and
even after trying the tips here I still have the problem.
Here is the formula in VBA:
Var1 = Round(1.25 * Var2, 2)
The value of Var2 is '.5'. After rounding, the result of
this should be '.63', and it keeps coming out to '.62' no
matter what I do. Var2 is defined as currency; I
originally defined as single. Same with Var2 -- Var2 is
also defined as currency; I originally defined as single.
What does it insist on rounding down when it should round
up?