Removing dashes from a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using:
Windows 98
Access 2002


I have a text field that shows SSN's like this:
111-11-1111
I want to remove the "-". What is the best way? An update query?

Thanks in advance!
 
built a function like this and on use it on your update query

Function ReplaceQ(pString1 As String, pFind As String, pReplacement As
String) As String

ReplaceQ = Replace(pString1, pFind, pReplacement)

End Function
 
Back
Top