>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement