Format report field as currency?

Spyder1000 · Jan 16, 2006

I use the standard:

Code:

<%=RS("cost")%>

to pull a dollar figure from my table. i'd like the field to display as a dollar amount on the webpage. any help would be greatly appricated.

ChrisHirst · Jan 16, 2006

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

Spyder1000 · Jan 16, 2006

Thanks. I found that on google in an earlier search. I guess I don't understand how to combine

Code:

<%=RS("cost")%>

with

Code:

<% =FormatCurrency(31567, 2) %>

DotNetGnat · Jan 16, 2006

this is how you do it:

<%=FormatCurrency(RS("cost"),2)%>

that gives you 2 decimal digits..so change it accordingly...

-DNG