If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Masking a field in Report only
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? |
#2
|
|||
|
|||
Masking a field in Report only
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" wrote in message ... 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? |
#3
|
|||
|
|||
Masking a field in Report only
Woot! That was it! Thank you very much for your help!
"Al Campagna" wrote: 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" wrote in message ... 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? . |
Thread Tools | |
Display Modes | |
|
|