capogna1
Member
- Local time
- Today, 07:45
- Joined
- Aug 8, 2019
- Messages
- 46
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 either SSN with dashes and without?
Thanks in advance for any response.
Robert
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 either SSN with dashes and without?
Thanks in advance for any response.
Robert