VBDever
Jan 29th, 2001, 03:42 PM
Help I have an ASP page that call a function that writes recordset data in to a table that's displayed. It returns a recordset variable that I add a formatting mark to and let fly into the table. For example I do the following:
Response.Write "<td align=right>" & chr(36) & rs0.Fields("YTDAppliedSales") & "</td>" & vbCrLf
Chr(36) makes that currency mark that I need.
I need to format the variable in such a way that it also will have a comma when it needs one (at every 3 place). That way I don't end up with $1000.00. I would end up with $1,000.00. Any ideas?
Response.Write "<td align=right>" & chr(36) & rs0.Fields("YTDAppliedSales") & "</td>" & vbCrLf
Chr(36) makes that currency mark that I need.
I need to format the variable in such a way that it also will have a comma when it needs one (at every 3 place). That way I don't end up with $1000.00. I would end up with $1,000.00. Any ideas?