Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access phone numbers (XP)

    Hi,

    I have two tables with phone numbers in test format. One shows 999-999-9999 the other 9999999999. I need to remove the 'dashes' from the first table so I can link the tables by the phone numbers. Any suggestions will be greatly appreciated.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access phone numbers (XP)

    First make sure that the dashes are really part of the data; if the field has an input mask they might be a display-only feature.

    If the data do contain dashes, you can create a query based on the table with a calculated field
    <code>
    Phone2: Replace([Phone],"-","")
    </code>
    where Phone is the name of the phone number field. Save this query.
    You can then create a new query based on the first query and on the other table, and link them on Phone2 vs the other phone number field.

  3. #3
    New Lounger
    Join Date
    Jan 2003
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access phone numbers (XP)

    Hans,

    Thank you very much, exactly what I needed.

    Len

Posting Permissions

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