Make Table qry - trim SSN to last 4 digits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a new table from an existing table to be used for an on-line
license renewal process. I don't want to put the entire SSN on the web but
need the last four numbers to verify the user's identity during the log on
process.

Would would be the proper syntax in the make table query so that SSN
XXX-XX-0000 in the original table shows up as 0000 in the new table?

I am currently using Access 2000 but will be upgrading to 2003 in the next
few months, if there are any differences between the two.

Thanks for your help!
 
I need to create a new table from an existing table to be used for an on-line
license renewal process. I don't want to put the entire SSN on the web but
need the last four numbers to verify the user's identity during the log on
process.
Click to expand...

Even begging the question about the complete inadequacy of the SSN as
a unique identifier (it's illegal to use it for the purpose, some
people validly don't have one, many people have fake ones), the last
four digits are even LESS reliable. That is your call though.
Would would be the proper syntax in the make table query so that SSN
XXX-XX-0000 in the original table shows up as 0000 in the new table?
Click to expand...

A calculated field

Right([SSN], 4)


John W. Vinson[MVP]
 
Even begging the question about the complete inadequacy of the SSN as
a unique identifier (it's illegal to use it for the purpose, some
people validly don't have one, many people have fake ones), the last
four digits are even LESS reliable. That is your call though.
Click to expand...

John, thank you for the answer to my question. As far as your above
comment, I work for a state agency that licenses and regulates certified
public accountants. We are required by law to have the SSN from each
individual and it is a key field. For on-line purposes it is far better to
have only the last four numbers as a part of the login process than the
entire number, don't you think?
 
John, thank you for the answer to my question. As far as your above
comment, I work for a state agency that licenses and regulates certified
public accountants. We are required by law to have the SSN from each
individual and it is a key field. For on-line purposes it is far better to
have only the last four numbers as a part of the login process than the
entire number, don't you think?
Click to expand...

Yep. You'll still have duplicates of course - Blaine Accounting might
have ssn 555-55-1234 and Wayne Accounting might have 654-32-1234 - but
it will at least be somewhat of a filter.

John W. Vinson[MVP]
 

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

Trimming SSN to last 4 digits 3
Sort Last 4 Numbers of SSN 2
How do I extract the last 4 digits of SSN? 4
Compare two tables using last four of SSN 2
how do I show the last 4 digits of a SSN in Access 2000 4
Trim all but the last four digits off a list of SSN's. 2
Import data 1
Make Table query not populating 3

Back
Top