Formatting currency in a FrontPage Results page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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
 
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.
 
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
Click to expand...
Click to expand...
 
Back
Top