The manual does say 'Use the Currency data type instead of Numeric for monetary values. If you specify more than four decimal places in a currency expression, Visual FoxPro rounds to four places before evaluating the expression...'. However, this is a serious thing and I for one do not believe that this explanation is in any way sufficient to explain the effect of following the [very clear] recommendation to use currency rather than numeric values at the beginning of the above quote. I can see now that I was foolish, but that does not make me any less pi...ed off. I now have to go back and change approximately 1000 fields in my database to numeric values and who knows what trouble that is going to cause. I have discovered some other little goodies - gomonth will not accept a number that is of type currency.
I have now RTFM and my question now becomes- Of what use is the currency type if you can't do any d..m thing with it.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!