Masking a field in Report only

  • Thread starter Thread starter messingerjc
  • Start date Start date
M

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?
 
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."
 
Woot! That was it! Thank you very much for your help!

Al Campagna said:
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 said:
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?
Click to expand...


.
Click to expand...
 
Back
Top