SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Having trouble with CURRENCY value's in Access

    I currently have a field set for Currency and the decimal places to 4. I have tried 2 and then I tried 4. If the price I have in that field ends in any kind of zeros,

    SUch as,

    $42.00

    When I view it via a coldfusion page, it reads as 42

    I can't get it to output the .00 part? I feel its necessary.

    Any help?

    Thanks
    Bryan

  2. #2
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    Why not just add the .00 if you don't detect a period in the return value?

  3. #3
    SitePoint Wizard jag5311's Avatar
    Join Date
    Jan 2003
    Location
    Somewhere in Indiana
    Posts
    3,082
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I didn't think taht I needed to start doing detections simply for adding decimal places. I mean, MS access 2002 has a thing that says, DECIMAL PLACES

    AUTO
    1
    2
    etc..

    So I thought that picking then number you want won't automatically round the numbers, but display what you want it to display.


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
  •