Masking a field in Report only

[messingerjc]

One of the fields in my main table has a social security number. I have the
formatting correctly showing the dashes. I have a few different reports, some
show the full social, while others I would like only the last 4 of the social
to show. ie. xxx-xx-1234
How would I format that correctly in just those particular reports?

 

[Al Campagna]

messingerjc,
Given a Social Security Number field (ex. [SSN])
In your qyery behind the report, create a calculated field...
SSNLast4 : "*** - ** - " & Right(SSN, 4)

Place [SSNLast4] on your report.

This will display as...
*** - ** - 6789
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[messingerjc]

Woot! That was it! Thank you very much for your help!

messingerjc,
Given a Social Security Number field (ex. [SSN])
In your qyery behind the report, create a calculated field...
SSNLast4 : "*** - ** - " & Right(SSN, 4)

Place [SSNLast4] on your report.

This will display as...
*** - ** - 6789
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

One of the fields in my main table has a social security number. I have
the
formatting correctly showing the dashes. I have a few different reports,
some
show the full social, while others I would like only the last 4 of the
social
to show. ie. xxx-xx-1234
How would I format that correctly in just those particular reports?

.