Trimming SSN to last 4 digits

  • Thread starter Thread starter KnowEnough2BDangerous
  • Start date Start date
K

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort Last 4 Numbers of SSN 2
how do I show the last 4 digits of a SSN in Access 2000 4
last 4 of SSN 5
How do I extract the last 4 digits of SSN? 4
Make Table qry - trim SSN to last 4 digits 5
Display Last 4 Digits Error 2
Keep Leading SSN Zero When Exporting To Text File 3
Compare two tables using last four of SSN 2

Back
Top