Trimming SSN to last 4 digits

[KnowEnough2BDangerous]

I created an Access database before ID theft was even thought of and would
push my clients' info to a handheld device with SSN and birthdates if I ever
had to request info from the Home Office.

So now I have this database of thousands of clients and I need to trim off
all but the last 4 digits of thier social security numbers and I'm struggling
to find out how to do such in a query that would then create the export CSV
or report.

Thanks!

 

[Roger Carlson]

Use:

Right(SSN,4)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[mscertified]

Right$(SSN,4)

Please don't store SSN in an Access database!

-Dorian

 

[KnowEnough2BDangerous]

Curious, why would you suggest not storing SSN's in an Access database?" Of
course, we use Windows EFS on the folder the db's are in.