Hide data

[Rustman]

Ok, here is the issue. I have to create a report listing participants in an activity. My table for people uses the full Social Security number because (when I figure out how to do it), I'll be having people log themselves in utilizing a common access card that is dependent on their full SSN for identification. Administratively, I need the last 4 numbers of their SSN on the report, but for security, I don't want the entire SSN on it. Is there any way to mask over the first 5 digits of the SSN in the report (similiar to using *** to hide passwords) or, even better, just don't display those numbers at all? As a last ditch solution, I can use the full SSN as the table key and have a seperate table entry for just the last 4, but that seems redundant and I'd rather not have to do that. Thanks! :-)

[June7]

You can mask or extract the last four digits with an expression. Is the SSN saved with or without hyphens:

Mid([SSN],6,4)
or
Mid([SSN],8,4)