M
Mark C via AccessMonster.com
I import data daily. when I get phone numbers they can be in any of the
following formats
9999999999
(999) 999-9999
999-999-9999
(999)999-9999
I have created an update query that does the following
Uptate to: replace([homephone],"(" and ")" and "-" and " ", "")
it works mostly but on random phone numbers it takes off a number.
Any ideas?
following formats
9999999999
(999) 999-9999
999-999-9999
(999)999-9999
I have created an update query that does the following
Uptate to: replace([homephone],"(" and ")" and "-" and " ", "")
it works mostly but on random phone numbers it takes off a number.
Any ideas?