>Hi all
>
>I understand that using Currency field may need to calculation inaccuracy without using MTON() function to first convert it into numeric. I would appreciate if you could advise what then are the benefits of using Currency field instead of Numeric field when designing database.
>
>Thanks & Best Regards

In the case in which you want that the result of an algebraic sum
doesn't depend on the order of the addends.

clear
a=1.0000000
b=0.1000000
c=0.2000000

? (b+c-b-c)*a=(b-b+c-c)*a

* With Numerics you should to use ROUND(),
* but the implementation of ROUND() is incorrect
* and exists results where it fails
? ROUND((b+c-b-c)*a,7)=ROUND((b-b+c-c)*a,7)