If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format for phone number
Hello:
I have a table with a phone column having a 999999-9999 format. I need (999)999-9999 or at least even a 999 999-9999. Any help will be greatly appreciated! Sandy |
#2
|
|||
|
|||
Format for phone number
if all your numbers are formed as indicated, make an
update query with the phone number field updated to "(" & Left([yourphonenumfield],3) & ") " & Right ([yourphonenumfield],8) SAVE A SAFETY COPY of your original table before running the update query on it. If you don't get the update string correct you'll lose the original data, perhaps irretrieveably. Hope this helps. -----Original Message----- Hello: I have a table with a phone column having a 999999-9999 format. I need (999)999-9999 or at least even a 999 999-9999. Any help will be greatly appreciated! Sandy . |
#3
|
|||
|
|||
Format for phone number
forgot to mention - make sure your phone number field is
big enough to hold the newly formatted string. The original strings are 11 chars; the new ones will be 14. -----Original Message----- if all your numbers are formed as indicated, make an update query with the phone number field updated to "(" & Left([yourphonenumfield],3) & ") " & Right ([yourphonenumfield],8) SAVE A SAFETY COPY of your original table before running the update query on it. If you don't get the update string correct you'll lose the original data, perhaps irretrieveably. Hope this helps. -----Original Message----- Hello: I have a table with a phone column having a 999999-9999 format. I need (999)999-9999 or at least even a 999 999-9999. Any help will be greatly appreciated! Sandy . . |
#4
|
|||
|
|||
Format for phone number
Thanks you very much.
I'll give it a try. Sandy |
Thread Tools | |
Display Modes | |
|
|