Compare two fields in Access to see if one contains the other?

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

Guest

I have a Client Acct Number field that might contain the patient's social
security number. What would be the query to find these?
 
Select all Client Acct Number with 9 digits or all Client Acct Number with
11 digits and dash.
 
Do you have the patient's SSN in a separate field in the same table? Are the
two fields both text fields?

If so, you could run a query with the following:
Field: Client Acct Number
Criteria: LIKE "*" & [SSN] & "*"

SQL would look like:
SELECT *
FROM [Your Table]
WHERE [Client Account Number] LIKE "*" & [SSN] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-Value Field Query 0
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Update Query 2
Query to see what percentage of people scored a specific number 1
IIF statement to compare two fields. 3
Matching Multiple Records 2
Remove numbers from beginning of social security number 4
Query for unmatched records within field values? 8

Back
Top