Banker's Rounding Pitfall

[Gregor y]

Be aware when porting Round(,) from MS-Access 2013 that it does Banker's Rounding (aka round half to even):

Round(0.00499,2)=0.00
Round(0.00500,2)=0.00
Round(0.00501,2)=0.01
...
Round(0.00999,2)=0.01
Round(0.01500,2)=0.02
Round(0.01501,2)=0.02
...
Round(0.01999,2)=0.02
Round(0.02500,2)=0.02
Round(0.02501,2)=0.03
...
Round(0.02999,2)=0.03
Round(0.03500,2)=0.04
Round(0.03501,2)=0.04

Ported to RoundUp environments:

Please Login or Register  to view this content.

Also Note: the above formula assumes you can *200 without overflow

Moreover the field type/precision also can throw Access off:

Please Login or Register  to view this content.