VBjunkie
May 30th, 2006, 06:37 PM
I'm trying to format a column to currency on a SQL report.
I need to allow for up to 4 places right of the decimal. (i.e. $5.1234)
Most of the time I will not have 4 places to the right of the decimal and don't want to see this if the user enters 1 dollar (i.e. $1.0000)
How do i make it so that it would display one dollar as ($1.00 not $1.0000) and display 5.2341 as ($5.2341)
Pretty much, if it has 2 decimal places or none at all than display 2 zeros and if it has more than only show what it needs up to 4 places to the right of the decimal.
I need to allow for up to 4 places right of the decimal. (i.e. $5.1234)
Most of the time I will not have 4 places to the right of the decimal and don't want to see this if the user enters 1 dollar (i.e. $1.0000)
How do i make it so that it would display one dollar as ($1.00 not $1.0000) and display 5.2341 as ($5.2341)
Pretty much, if it has 2 decimal places or none at all than display 2 zeros and if it has more than only show what it needs up to 4 places to the right of the decimal.