Masking SSNs with ***-**-xxxx

[MichaelG]

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

 

[fredg]

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

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

="***-**-" & Right([SSN],4)