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:
Also Note: the above formula assumes you can *200 without overflow
Moreover the field type/precision also can throw Access off:
Bookmarks