Is there a way to query or search for the last four digits in SSN field
Windows 7 32bit 
Access 2010 32bit
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;;_
Reply With Quote
