formatting text field to show numbers only

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

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?
 
Use an update query with a calculated field:

FixPhone: Replace(Replace(Replace([PhoneNu], "(", ""), ")", ""), "-","")
 
It the input format is always the same:

NewNum = Mid([Input],2,3) & Mid([Input],6,3) & Right([Input],4)
 
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?
Click to expand...
 
Back
Top