changing the design of a telephone nnumber

B

buckpeace

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

fredg

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
 
Top