|
| |
|
|
mmoore0319
Posts: 25
Joined: 10/17/2005
Status: offline
 |
Display Columns Results as Currency - 7/2/2007 18:28:05
Hello, me again. I have run into another issue and would appreciate any assistance.
How do I arranged column display results as currency? I have tried to implement the Format(myAmount,'$#,##0.00') approach but I'm apparently not using the correct syntax.
Any recommendations for the correct syntax to use? Below is the portion of the page in question:
fp_sQry="SELECT * FROM ManufactureTotals"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=9 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="CreditsDue"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Manufacturer"
fp_sMenuValue="Manufacturer"
fp_sColTypes="&Manufacturer=202&Balance=6&Cur=6&Aged30=6&Aged60=6&Aged90=6&Aged120=6&SumOfAgedOut1=6&AgedPer=5&"
fp_iDisplayCols=9
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Manufacturer" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Manufacturer<font size="-1">>></font>" s-ColumnTypes="202,6,6,6,6,6,6,6,5" startspan --><%=FP_FieldVal(fp_rs,"Manufacturer")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Balance" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Balance<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Balance")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Cur" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Cur<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Cur")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Aged30" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Aged30<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Aged30")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Aged60" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Aged60<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Aged60")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Aged90" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Aged90<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Aged90")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="Aged120" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Aged120<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Aged120")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="SumOfAgedOut1" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>SumOfAgedOut1<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"SumOfAgedOut1")%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
<td><!--mstheme--><font face="Arial, Helvetica"><font size="1">
<!--webbot bot="DatabaseResultColumn" s-columnnames="Manufacturer,Balance,Cur,Aged30,Aged60,Aged90,Aged120,SumOfAgedOut1,AgedPer" s-column="AgedPer" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>AgedPer<font size="-1">>></font>" startspan --><%=FormatPercent(FP_FieldVal(fp_rs,"AgedPer"))%><!--webbot bot="DatabaseResultColumn" endspan --><!--mstheme--></font></td>
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Display Columns Results as Currency - 7/2/2007 21:11:58
Remember the FormatPercent function you used? There is also a FormatCurrency function. You use it the exact same way.
http://www.w3schools.com/vbscript/func_formatcurrency.asp
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
mmoore0319
Posts: 25
Joined: 10/17/2005
Status: offline
|
RE: Display Columns Results as Currency - 7/3/2007 12:27:41
Geez! I need to bang my head on desk since this was so obvious a fix.
Thanks for the great help, as always.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
