Professional Web Applications Themes

How do I view currency field in format $xx.xx - ASP Database

Hi everybody, I would like to know how do I view a value that has a currency type (Access) in the format $xx.xx. An example of what I would like to see is $49.99. I am using ASP as the scripting language. Thanks in advance Terry...

  1. #1

    Default How do I view currency field in format $xx.xx

    Hi everybody, I would like to know how do I view a value that has a currency
    type (Access) in the format $xx.xx. An example of what I would like to see
    is $49.99. I am using ASP as the scripting language.

    Thanks in advance

    Terry


    Terry Murray Guest

  2. #2

    Default Re: How do I view currency field in format $xx.xx

    Conveniently enough, there is a FormatCurrency function in VBScript, if that
    is the language you're using. (It's there even if that's not the language
    you're using, but you know what I mean.)

    [url]http://msdn.microsoft.com/library/en-us/script56/html/vtoriVBScript.asp[/url]
    [url]http://msdn.microsoft.com/library/en-us/script56/html/vsfctformatcurrency.asp[/url]

    Ray at work

    "Terry Murray" <tgmurrayrogers.com> wrote in message
    news:arSrb.13290$Rah1.3856twister01.bloor.is.net. cable.rogers.com...
    > Hi everybody, I would like to know how do I view a value that has a
    currency
    > type (Access) in the format $xx.xx. An example of what I would like to
    see
    > is $49.99. I am using ASP as the scripting language.
    >
    > Thanks in advance
    >
    > Terry
    >
    >

    Ray at Guest

  3. #3

    Default Re: How do I view currency field in format $xx.xx

    [url]http://www.aspfaq.com/2188[/url]





    "Terry Murray" <tgmurrayrogers.com> wrote in message
    news:arSrb.13290$Rah1.3856twister01.bloor.is.net. cable.rogers.com...
    > Hi everybody, I would like to know how do I view a value that has a
    currency
    > type (Access) in the format $xx.xx. An example of what I would like to
    see
    > is $49.99. I am using ASP as the scripting language.
    >
    > Thanks in advance
    >
    > Terry
    >
    >

    Aaron Bertrand [MVP] Guest

Similar Threads

  1. Question Currency format null when = 0
    By Lulu in forum Brainstorming Area
    Replies: 0
    Last Post: November 17th, 09:49 PM
  2. format currency
    By RK in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: May 15th, 06:13 PM
  3. Format Currency in ASP?
    By jason in forum ASP
    Replies: 3
    Last Post: August 25th, 10:28 PM
  4. Format Textbox on exit to Currency
    By Patrick J. Schouten in forum ASP
    Replies: 4
    Last Post: July 14th, 11:17 AM
  5. format number into currency format ($1,000,000.00)
    By Aaron Bertrand - MVP in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 11th, 06:31 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139