I have also had trouble with rounding in Access Currency. The internal form

of currency is scaled integer but the implementation uses 4 digits of

fraction instead of just 2 (pennies). The result is still an indefinite

rounded result.

The only perfect solution I have found was to do the scaling myself. Use

long integer format and on entry multiply each value by 100. Do this for ALL

money variables. After any division, do a suitable rounding operation,

truncate and store in the long integer form again. This is the only way I

was able to get the calculated sum of a column of numbers to agree with the

actual sum.

Hugh

"Dalan" <ot***@safe-mail.net> wrote in message

news:50*************************@posting.google.co m...

Is there any code available to address currency rounding problems in

Access 97? Apparently, selecting currency type table fields does not

resolve the problem. For instance, in my form I have a price of item

field (say $49.95), and a percentage discount field (say 10% = $5.00),

and calculated net cost field of the two. Access seemingly doesn't

understand banker's rules as the resulting total is $44.96. Could this

be a bug? Why does it miscalculate with currency numbers?

Thanks for your comments. Dalan