Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Format (99,9999.99) by using STR()
Message
From
14/06/2003 11:11:49
Jorge Aguirre Streic
Jorge Aguirre Streicher
Tijuana, Mexico
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00800116
Message ID:
00800121
Views:
18
this code can solve do that.
regards
Jorge Aguirre

cSumComision = ALLTRIM(STR(vPT,14,2))

vTG = "TOTAL: $" + Iif(Len(cSumComision) > 6, Iif(Len(cSumComision) > 9, Substr(cSumComision,1,Len(cSumComision)-9) + "," + Substr(cSumComision,Len(cSumComision)-8,3) + "," + Substr(cSumComision,Len(cSumComision)-5,6), Substr(cSumComision,1,Len(cSumComision)-6) + "," + Substr(cSumComision,Len(cSumComision)-5,6)), cSumComision)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform