Results 1 to 3 of 3

Thread: Currency Field?

  1. #1
    Join Date
    Jul 2003
    Location
    Japan/California
    Posts
    68

    Arrow Unanswered: 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

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    FormatCurrency(fieldName)

  3. #3
    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 23:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •