Results 1 to 4 of 4

Thread: Reformatting

  1. #1
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    Unanswered: Reformatting

    I was given an excel sheet, phone numbers were imput as ###-###-####. Now my boss wants them to look like (###) ###-#### in acess. I tried an update query. no dice. Any hints.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    remove the -'s, store the phone #'s as a numeric datatype and apply the built-in phone number mask.

    The alternative...

    "(" + Left$(field, 3) + ") " + Mid$(field, 5, 3) + "-" + Right$(field, 4)

    But really, you should go with the first options, what happens when he wants it changed back?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Thanks got it

  4. #4
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    What IS goin on??

    oK, I made the numbers look how I wanted, and now am inserting new people, I When I put it in and moved on it looked correct. I closed and opened the tbl, it looked fine. I opened a report and all the new people's numbers are displayed (@@(@)@@@--@@@@. Then go back to the table and they are also displayed that way. Any Idea?
    Ryan
    My Blog

Posting Permissions

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