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
 
Back
Top