Removing dashes from a text field

[JC Newsgroup]

Using Access 2002

The data in my field looks like this:
111-11-1111

I want to remove the dashes "-".


What is the best way? An update query?

Thanks in advance.

 

[John Nurick]

Hi JC,

Yes: use the VBA Replace() function in an update query.