Format for phone number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Sand
 
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.
 
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


.
Click to expand...
.
Click to expand...
 
Back
Top