Formatting currency in a FrontPage Results page

M

Meemers

I"m pulling price info from a database. The price field in the database is
formatted as currency but the results page it is not showing as currency. I
tried changing the field to a text field but then it doesn't sort correctly.
How do I format the resulting field as currency ie $1,300,995 ?
 
S

Stefan B Rusynko

See http://www.devguru.com/technologies/vbscript/quickref/formatcurrency.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I"m pulling price info from a database. The price field in the database is
| formatted as currency but the results page it is not showing as currency. I
| tried changing the field to a text field but then it doesn't sort correctly.
| How do I format the resulting field as currency ie $1,300,995 ?
| --
| Hopeful Thanks
| Meemers
 
M

Meemers

Thank you - but the item I am trying to format as currency is the value of a
field from a database - how do I get that into the expression? It's a webbot.
 
K

Kathleen Anderson

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


Meemers said:
Thank you - but the item I am trying to format as currency is the value of
a
field from a database - how do I get that into the expression? It's a
webbot.
--
Hopeful Thanks
Meemers


Stefan B Rusynko said:
See
http://www.devguru.com/technologies/vbscript/quickref/formatcurrency.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| I"m pulling price info from a database. The price field in the database
is
| formatted as currency but the results page it is not showing as
currency. I
| tried changing the field to a text field but then it doesn't sort
correctly.
| How do I format the resulting field as currency ie $1,300,995 ?
| --
| Hopeful Thanks
| Meemers
 

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

Top