last 4 of SSN

[Guest]

If I have a database with SSNs in it, how can I develop a query
-- that shows only the last 4 of the SSN?
Lou7

 

[PC Datasheet]

Put the following expression in an empty query field:
LastFourDigits:Right([SSN],4)

 

[John Spencer (MVP)]

Field: Last4: Right([YourTable].[YourField],4)


SQL Text would look something like:
SELECT Right([YourTable].[YourField],4) as Last4
FROM [YourTable]

 

[Guest]

I have tried these suggestions and none seem to work. I will keep on trying.
thanks Maybe I am not doing it correct
lou7

Put the following expression in an empty query field:
LastFourDigits:Right([SSN],4)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If I have a database with SSNs in it, how can I develop a query
-- that shows only the last 4 of the SSN?
Lou7

 

[Chris2]

I have tried these suggestions and none seem to work. I will keep on trying.
thanks Maybe I am not doing it correct
lou7

lou7,

Will you let us in on what did happen when you tried it?


Sincerely,

Chris O.

 

[Guest]

Got it.
Thanks so very much!

lou7,

Will you let us in on what did happen when you tried it?


Sincerely,

Chris O.