Format a Currenct Field

[mlocurci]

I have an asp page that reads from an Access Db. The one field that is read, is a price field. When it gets to the web, its just a number. What can i do?

SELECT CCur(Sum([GCAmount1]+[GCAmount2]+[GCAmount3]+[GCAmount4]+[GCAmount5]+[GCAmount6]+[GCAmount7]+[GCAmount8]+[GCAmount9]+[GCAmount10]+[GCAmount11]+[GCAmount12]+[GCAmount13]+[GCAmount14]+[GCAmount15])) AS CalcTotal
FROM giftCardSales INNER JOIN ShippingMethods ON giftCardSales.ShippingOption = ShippingMethods.ShippingMethod;

 

[Tarwn]

'pretend rs is the record set and price is the currency field
Response.Write "$" & rs("price")
or
Response.Write FormatCurrency(cCur(rs("price")),2)

The FormatCurrency function is defined something like this:

FormatCurrency(Expression [,NumbersAfterDecimal [,IncludeFrontDigit [,ParensForNegativeNumbers(?) [,DigitGroup(?)]]]])

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html