>>>The value actually stored in a field is 27 cents
>>>
>>>Tue question is if I multiply that value (27 cents) by 3 percent will the result be OK (.2781) or still 27 cents because there can only be two decimal places for a currency ?
>>
>>Currency data type stores 4 decimal places.
>>
>>Michelle
>
>Is it true that calculations with Currency fields are faster than with numeric fields?
>
>And another question:
>Are four decimal places always enough? Some people use numeric fields with 6 decimal places in certain applications. But I don't know whether this makes sense.
Sorry, don't know if it's faster. As to whether they are enough, I think that really depends on the application. Practically, though, I can't imagine most business apps needing to divide a penny any further. :)
Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only