Results 1 to 4 of 4

Thread: comma separator

  1. #1
    Join Date
    Nov 2010
    Posts
    8

    Unanswered: comma separator

    I enter currency or number data into a cell with comma separator, like this 5,250 or 5,250. The separator shows up correctly in the access table.

    When I pull this out from a .asp recordset the comma is not there, just get 5250

    When I test the SQL statement in dreamweaver the comma is also not shown.

    How do I get the comma separator to display ?

    It works ok if I enter as text or memo, but I want to sort on price ascending which means entering as a number or currency.



    Thanks in advance
    Last edited by jacey100; 03-31-11 at 19:50. Reason: typo

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    the database will be storeing the number as a number

    in asp you will need to use

    formatcurrency(feildname,2)
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    to back up what myle is saying
    don't confuse the storing of data with the presentation of data.

    if for no other reason consider your spreadheet designed with a comma as a thousand separator, if that same app was to go to, say France or Italy where they use a comma as the equaivalent to the point... ie it identifies the decimal part of a number.
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Nov 2010
    Posts
    8
    Thank you Myle and Healdem. It now works just fine !!

    And i'd rather be riding my street metisse

Posting Permissions

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