G Guest Mar 30, 2006 #1 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
F fredg Mar 30, 2006 #2 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)
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)