Hi everyone,
I have a field with social security numbers, data was imported so some came in with dashes some without. Tried to change format to the field to get rid of dashes but didn't work. Now when I search by SSN I have to try with dashes and without. How do I tell Access bring be back...