General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Why does the Currency field type carry 4 decimals, and if it is used in a form textbox or report control, how should it be formatted so it only displays 2 decimals?
>>
>>Seems like a bother to me. Why not just use N(10,2)?
>
>I think it only displays 2 decimals anyway. Also nothing prevents you from using NUMERIC for monetary values.
>
>You can also look at SET DECIMALS command.
That's what I've been doing. If the fieldtype is Currency it shows 4 decimals in the textbox and any report fields. Then you have to deal with special formatting parameters to show only 2 decimals.
Previous
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