Only Show Last 4 Digits of SSN on Report 1

[mommom]

I have a report that has

LastName
FirstName
MI
DOB
POB
SSN
Date of Visit

When the report is given to the from office they just want them to have the last 4 digits. Is there a query that can be used to reflect that on the report.

Thanks for your help.

 

[Knicks]

=Right([ssn],4)

 

[mommom]

Knicks,

Are you putting it in the query or under the input mask? I tried the query, and it didn't work.

 

[mommom]

When I put my code in the query it keeps asking me to enter a parameter value. I want it to open up the report and show a list of ALL SSN's with the last 4 digits.

 

[Knicks]

I put it in the query, up where you normally put fields (not criteria)

 

[MichaelRed]

somewhat off topic, but I have often wondered what is the point of this practice (and it is a common one). Since you provide only slightly more than half of the identifier, these seems little possability of using it as any reasonable index / identity, etc., ah what is the purpose?




MichaelRed

 

[TheAceMan1]

How are ya mommom . . .

[blue]Knicks[/blue] is on target. You need to create a custom field in the query. In the [blue]first blank field[/blue] in the [blue]field row[/blue], copy/paste one of the following:

[blue]SSN4:Right([SSN],4)
   or
SSN4:"***-**-" & Right([SSN],4)[/blue]

In the report use the [blue]SSN4[/blue] field instead of [blue]SSN[/blue].

See Ya! . . . . . .

 

[VicRauch]

MichaelRed:
Your right, it is off topic.
The last 4, plus your name, address, phone number, etc. can be used by PEOPLE to identify that the PEOPLE in the office are talking to the right person. That is why this was for a report, not a file. Plus, the actual SSN is not being printed on a piece of paper and thus presenting the company with another possible way to have identity thieft made easier within their company.

 

[mommom]

Thanks that works now, just have one problem.
On the query it shows up as the SSNID Autonumber even though on the table I set up the width and the column count. How do I change the query to show the last four and not the Autonumber.

 

[Knicks]

Anything on the left side of the ":" will become the new field name (you don't want to use the old field name, make it new like suggested ssn4). If you don't put anything to the left of the colon, Access automatically assigns expression1, ect..

This new field name should then be available in your report or form. I have no idea how your autonumber got hooked up into this. Simply delete that field and add the new one created in the query

 

[Knicks]

SSN4:Right([SSN],4)


Simply use that on the top line of the query grid as an expression. When you view either form or report in design mode you should see as a field "SSN4", drag it down and use it.