Need to show only the last four digits of SS# on report

[Guest]

I'm trying to run a report from a query. The query shows the full social
security number, but on the report I need to only show the last four number.
Any suggestions?

 

[RobFMS]

Select Right( [SSN], 4) as SSN

HTH

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Guest]

Use "Right" in vb.

Here's an example...

Dim stSocial, stPartial

stSocial = Me.YourSocialField
stPartial = Right(stSocial, 4)

Me.MyReportField = "XXX-XX-" & stPartial

HTH

Aaron G
Philadelphia, PA

 

[Guest]

Rob, thanks for your input, but when I tried it, nothing on the report
showed. What am I doing wrong? I entered right([ssn],4) in the criteria
under the SS# column. Am I putting the formula in the wrong place? I really
appreciate your suggestions.

 

[Rick B]

Just add an unbound text box to your report and put the following in it...

= Right([SSN],4)

 

[fredg]

Rob, thanks for your input, but when I tried it, nothing on the report
showed. What am I doing wrong? I entered right([ssn],4) in the criteria
under the SS# column. Am I putting the formula in the wrong place? I really
appreciate your suggestions.

I'm trying to run a report from a query. The query shows the full social
security number, but on the report I need to only show the last four number.
Any suggestions?

Yes you did this in the wrong place.
Do it in the report itself.
Add an unbound control where you wish to display the SS#.
Set it's control source to:
=Right([SSN],4)
or set it to:
="xxx-xx-" & Right([SSN],4)

depending upon how you would like to display it.

Change SSN to whatever the actual name of the Social Security field
is.

 

[Douglas J Steele]

Yes, you're putting it in the wrong place. You don't want it as a criteria,
you want it as a new computed column. Either that, or you use it as the
Control Source for your text box.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Rob, thanks for your input, but when I tried it, nothing on the report
showed. What am I doing wrong? I entered right([ssn],4) in the criteria
under the SS# column. Am I putting the formula in the wrong place? I really
appreciate your suggestions.

I'm trying to run a report from a query. The query shows the full social
security number, but on the report I need to only show the last four number.
Any suggestions?

 

[Guest]

Thanks so much everyone for your help. I really appreciate it.