Hi Calvin,
>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.
You can use it for amounts, even adding amounts, but not for calculations. Although a currency looks like a numeric value, it's not numerical, it's a currency. See it as an entirely different data type. Just like you can'r multiple a string with 0.000015, you can't multiply a currency with 0.000015. In both cases a so called type casting is necessary. In VFP we have only few type casting rules. Actually, I can only think of two:
Integer are converted to numericals when you perform a calculation with numeric values. And numeric values are converted to currency when you try to mix both. If you need something different, you have to use explicit type casting, like:
integer * INT(numerical)
or
MTON(currency) * numerical
Christof
--
Christof