Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: converting commas to decimals and vice versa

    I have a table in an Access 2003 database. This table has a column which has monetary values. As they were extracted from a greek database, the decimals are noted as "," and the comma separator value is noted as ".".

    I am unable to perform my analysis on this as a value of 3.456,23 which should be read as 3,456.23 is read as 3.45 etc.

    Please help urgently.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Since MS Access is NOT a server, I'm moving this thread to the correct forum.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    What database type was the data "extracted" from?

    If it was Access, just copy the entire .mdb file from their computer to yours, and the issue should be resolved. (Access stores numeric/date data in a consistent internal format, but displays the data in the regional windows format.)

    If your field types are text (which it sounds like,) you need to swap them as follows:

    First, replace all the commas (,) with a temporary character, the tilde (~) say, then replace all periods (.) with commas, and finally replace the tildes from the first step with periods.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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