>Naomi,
>I think the solution isn't in choice between
Numeric OR
Currency datetype field.
>The solution is in calculations and rounds in exactly steps in program or Report.
>For all your calculations and reports you need to use the same strategy for calculations and rounds.
But this is my problem. I use the exact same calculations except for the fact I'm using currency fields and the original table uses 9,2 numeric field.
Neither of the programs do any roundings, but I guess in case on Numeric 9,2 the results are less predictable.
If it's not broken, fix it until it is.
My Blog