Hello,
I have a table with a 9 digit SSN field. This number is followed by one or two additional characters (letters or numbers).
It may happen that same records have the same 9 digits and will need to create a query that returns all those records with just the same first 9 digits. Query source will be a textbox on a form.
Example:
Records:
000000000A
000000000B
000000000C
111111111A
123456789A
If in the textbox, the criteria is 000000000, then the query should return:
000000000A
000000000B
000000000C
Is there a way, I can achieve this?
Thank you for any help.
I have a table with a 9 digit SSN field. This number is followed by one or two additional characters (letters or numbers).
It may happen that same records have the same 9 digits and will need to create a query that returns all those records with just the same first 9 digits. Query source will be a textbox on a form.
Example:
Records:
000000000A
000000000B
000000000C
111111111A
123456789A
If in the textbox, the criteria is 000000000, then the query should return:
000000000A
000000000B
000000000C
Is there a way, I can achieve this?
Thank you for any help.