Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number or Currency?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00747637
Message ID:
00747746
Views:
16
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform