>I strongly advise NOT to use currency fields. I have used them and realized they don't work (at least not in my apps)
>I calculate interest for govenment bonds and they were hundreds of Dollars off.
>Changed the field type to N(17,2) and everything balances to the penny!
>
>(My 2 cents (numeric 10,2))
>
Peter,

The problem is NOT currency fields, it is when you do your rounding. For example, check the difference in these two sums;

           Values    Not Rounded   Rounded
            12.9999    12.9999       13.00
            12.1190    12.1190       12.12      
            12.9958    12.9958       13.00
            12.4998    12.4998       12.50
            50.6145    50.6145       50.62
Rounded to 2 decimals  50.61         50.62

This short list of 4 values is off by .02, if we had 100,000 transactions then the differnece would be 2,000.