how do I show the last 4 digits of a SSN in Access 2000

T

thesnyder

I am using Access 2000 and I need to create a mask that will only show the
last 4 digits of the social security number when I do a query. I have tried
the =Right([SSN],4) but that formula is not working for me. I get no results
at all when I do the query. I put the formula in the criteria box of the
query.
 
J

Jeff Boyce

If you put the "=Right([SSN],4)" in the criterion, you are telling Access to
find a record where the SSN = that value (i.e., with that value as the
selection criterion).

Instead, put that formula in a new field "box", telling Access to generate
something based on the formula.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff L

You want to put your Right([SSN],4) as a field and not in the criteria
of a field. Do not put the = in your field.
 
K

KARL DEWEY

Make sure the field is a datatype of text and then you want to put your
Right([SSN],4) as a field and not in the criteria of a field.
 

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
Right Function in a Report 4
How to display last for digits of SSN? 4
How do I extract the last 4 digits of SSN? 4
How to display SSN in Access showing only last four digits 1
Using the "RIGHT" function 3
Display Last 4 Digits Error 2

Top