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

[rdw1260]

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,

 

[SteveM]

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

 

[SteveM]

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

 

[John W. Vinson]

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,

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]