Using find to search last four characters of a social security num

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

Guest

I'm using Access 2003. Is there a way to search a SSN field for the last 4
characters of a social security number?

Thanks,
 
You can use the Right() function to return the specified number of characters
from the right of a string.

For your information, there is also a Left() function.

Steve
 
You can use the Right() function to return the specified number of characters
from the right of a string.

For your information, there is also a Left() function.

Steve
 
I'm using Access 2003. Is there a way to search a SSN field for the last 4
characters of a social security number?

Thanks,
Click to expand...

Put a calculated field in a Query by typing

LastFour: Right([SSN], 4)

in a vacant Field cell, and put a criterion of

[Enter last four digits of SSN:]

on the criteria line under it.

John W. Vinson [MVP]
 
Back
Top