Is there a way to query or search for the last four digits in SSN field

[Vetgeorge]

I have a search query with a field for the SSN. As I have it now, it works-in that someone can type in anywhere from one to nine numbers in the search form and the query will return the result, any SSN's that have those numbers in that particular sequence.
Example: you type in 1234 and you would get say SSN such as 123-45-6789, 912-34-5678, 555-12-3456, and so on.

What I would like is to be able to search for just the last four digits. Is this possible?



My current criteria in my SSN field in the query is:
Like "*" & [Forms]![frmSearch]![txtSSNumber] & "*"

Additionally, not sure if this will affect it, but I have the SSN field in my main table as an input mask: 000\-00\-0000;;_

[pbaldy]

Just drop the second wildcard:

Like "*" & [Forms]![frmSearch]![txtSSNumber]

You could also use the Right() function.

[Vetgeorge]

Thank you, it works! I said to myself "you eediot" when I saw how simple the solution was.

[pbaldy]

Happy to help!