rounding errors in access

[Guest]

I am trying to get Access 2003to round to 2 significant digits, but it keeps
truncating instead. For example, $1107 x 3.5% (or .035) is $38.745, and
should round to $38.75, but Access keeps calculating $38.74. $99 x 3.5% is
$3.465, and should round to $3.47, but Access gives me $3.46. My formula is
Round([DollarAmt]*[Percentage], 2), and I have also tried
Round(([DollarAmt]*[Percentage]),2), but to no avail. It calculates correctly
in Excel, but in Access it does not. I have tried this in both a report and a
query, to no avail.

 

[Douglas J. Steele]

Access uses what's know as "Banker's Rounding": if the digit preceding the 5
is even, it rounds down, and if it's odd, it rounds up. This is supposed to
reduce round-off error when summing a series of numbers.

You might find the following worthwhile:

PRB: Round Function different in VBA 6 and Excel Spreadsheet
http://support.microsoft.com/?id=194983
HOWTO: Implement Custom Rounding Procedures
http://support.microsoft.com/?id=196652