If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > Currency Field?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-20-03, 03:40
jonah9 jonah9 is offline
Registered User
 
Join Date: Jul 2003
Location: Japan/California
Posts: 68
Arrow Currency Field?

hello, just a quck question about currency fields:
i have a currency field in my access database that i want to display on the web, but by the time it gets to the web page all the dollar signs and commas are gone. how can i get them to show up?
thanks in advance,
Jonah
Reply With Quote
  #2 (permalink)  
Old 08-20-03, 13:54
Memnoch1207 Memnoch1207 is offline
Registered User
 
Join Date: Jan 2003
Location: Midwest
Posts: 138
FormatCurrency(fieldName)
Reply With Quote
  #3 (permalink)  
Old 08-20-03, 21:55
jonah9 jonah9 is offline
Registered User
 
Join Date: Jul 2003
Location: Japan/California
Posts: 68
Unhappy

sorry, i forgot to mention that i need the currency formatted in Japanese Yen. but you put me on the right track.
i ended up just typing in the yen symbol and using
formatnumber(rs.Fields("price").Value,0
to get rid of the dollar sign and decimal places.
thanks a bunch,
Jonah

Last edited by jonah9; 08-20-03 at 22:02.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On