>>>Hi,
>>>Should I use currency or Numeric N(14,2) data type for Cost, selling price and sales amount?
>>>
>>>Thank you
>>
>>I personally never use Currency to avoid all potential rounding problems with this field type.
>
>I knew there was a reason for me using numeric versus currency but I just couldn't think of it ;)
>
>Einar
I fixed a couple of somebody's applications by changing from Currency to Numeric. They were often 1-2 cents off in their calculations. No big deal really, but you know, accounting staff does not like this very much. :)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison