changing the design of a telephone nnumber

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

Guest

In an Access Query, I need to make this telephoen number (555)281-7107 to
read like: 5552817107 (no parenthesis or dash)

So new to Access and really need some help. I really appreciate it.
 
In an Access Query, I need to make this telephoen number (555)281-7107 to
read like: 5552817107 (no parenthesis or dash)

So new to Access and really need some help. I really appreciate it.
Click to expand...

NewPhone:
Replace(Replace(Replace(Replace([PhoneField],"(",""),")",""),"-",""),"
","")

Includes removing the space which is usually placed after the area
code (555) 281-7107
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to change format of data already entered 5
Snag in invoice generator. How to change the "series" 5
Parenthesis and periods in criteria 5
Update telephone numbers 1
Parenthesis as a criteria in a query. 6
Telephone Numbers 2
Alright you formula wizards 5
Mail Merge and Access format of telephone number 2

Back
Top