Replace Function

[hycho]

All,

I have to convert a large number of phone numbers to string with no symbols.

Such as, from (123) 456-789 to 123456789.

I tried using the replace function, and was wondering if there is a way I can enter multiple symbols to replace. Such as the function below (which didn't work):
Replace([phone],"-" Or "(","")


FYI, currently I have been exporting the file to Excel and using the find and replace feature to make the appropriate updates, and the import it back to Access,



Let me know if there is a better way of doing this.



Thanks

 

[Mr. B]

Try using the Left(), Mid() and Right() functions. Using these functions, you can create a statement that will return just what you need.