>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
Currency can save space for storing some data.
With currency, you will have exact results for addition and subtraction.
For calculations that include multiplications and divisions, it is sometimes problematic; almost any calculation that includes currency will be converted to currency, so you can lose accuracy (since only 4 digits are used). In many cases, you have to use mton() to convert to numeric first.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)