I see Microsoft Access is not consistent in rounding. Interesting I know...I am trying to do banker's round ie. round(1.235)=1.24
If you want to see the description of banker's rounding:
which is round it to nearest even number...
I need two digits after period just like I have above.
You can use this syntax to test in VBA:
Debug.Print Round(2.155, 2)
'I need this result to be 2.16