Masking SSNs with ***-**-xxxx

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

Guest

I am trying to find a way to display the SSN's in a report, query etc with
the last 4 only.
Thank you
 
I am trying to find a way to display the SSN's in a report, query etc with
the last 4 only.
Thank you
Click to expand...

Use an unbound control in the report.
Set it's control source to:

="***-**-" & Right([SSN],4)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make table query sorts data in wrong order 2
replace last four of ssn with xxxx 5
Query 2 tables, find records where the key matches 4
linking fields which may be incomplete 2
Total unique fields 2
Don't Include Duplicates 1
Import EXCEL data with a different data type 1
Can't figure this out 1

Back
Top