Convert Number to show as Comma Seperated or Currency

C

CSOS

I have Column Values being retrieved a Access DB.
Dsplay them in a form they show as a general number.

Current Display 100000
Desired Display $1,000,00

Code Snippet Being used
<% end if %><
fp_sQry="SELECT * FROM ""E: Pipeline Calcs""
fp_sDefault="
fp_sNoRecords="No records returned.
fp_sDataConn="SAIFDBCONNECT
fp_iMaxRecords=25
fp_iCommandType=
fp_iPageSize=
fp_fTableFormat=Fals
fp_fMenuFormat=Fals
fp_sMenuChoice="SumOfSumOfTCV
fp_sMenuValue="SumOfSumOfTCV
fp_iDisplayCols=
fp_fCustomQuery=Fals
BOTID=
fp_iRegion=BOTI
%
Thank you very much
CSOS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert record, increment a number by 1 0
Insert record, increment a number by 1 0
Loop and Insert record, increment a number by 1 0
No Records 2
No Results In Databse 1
Incomplete query clause 1
session variable 1
Can't fix ASP error 126 2

Top