>>>Have you tried looking at the value of mynumericvar before running TRANSFORM()? It it some strange number?
>>>
>>>Ed
>>
>>Hello Ed!
>>
>>Thanks for your quick answer!
>>The number is normal. But I have to modify the program lines I wrote earlier. The field is currency, not numeric. The select destination is table type. (not cursor).
>>In the last some minutes I read in MS KB, that Calculate sum on currency fields in cursor can cause problems - like my one - at subsequent lines in 5.0.
>>OK, but in this case it is not cursor, and I use 5.0 with serv pack 3, that means 5.0a.
>>P.S.: Now I found a works around, MS suggested it:
>>after calculating,
>>mynumericvar=val(str(mynumericvar))
>>
>
>Béla, probálj meg:
>Calculate sum(0.0+numericfield) to mynumericvar
>
>In any situation where Fox doesn't like to have some type of var in a function (like some functions disliking memos), it always helps to convert it to standard types. Adding a zero should make it a normal IEEE number instead of currency.

Hello Dragan,

kösz a választ!

I always wondered how to force VFP to convert from currency to normal numeric.

BB