formatting text field to show numbers only

[Russ via AccessMonster.com]

I am importing information in from another database that has a text field
with the following (815)555-1212, how can I remove everything via a query but
the numbers so it reads 8155551212?

 

[Klatuu]

Use an update query with a calculated field:

FixPhone: Replace(Replace(Replace([PhoneNu], "(", ""), ")", ""), "-","")

 

[kingston via AccessMonster.com]

It the input format is always the same:

NewNum = Mid([Input],2,3) & Mid([Input],6,3) & Right([Input],4)

 

[Russ via AccessMonster.com]

thanks for the help!

I am importing information in from another database that has a text field
with the following (815)555-1212, how can I remove everything via a query but
the numbers so it reads 8155551212?