Duplicate Query

  • Thread starter Thread starter P Brainard via AccessMonster.com
  • Start date Start date
P

P Brainard via AccessMonster.com

This is the Wizard created query to find records with matching SSN:

In (SELECT [SSN] FROM [01_26_05list] As Tmp GROUP BY [SSN] HAVING Count(*)
1 )
Click to expand...

I'd like to exclude all records that have different first names [FIRST_NAME]
- Any ideas?
 
To clarify:

If dupe SSN and first name is different, then exclude from results.
 
Try this in your Where clause:

WHERE ((([ssn] & [First_name]) In (SELECT [ssn]&[First_name] FROM
[01_26_05list] As Tmp GROUP BY [ssn]&[First_name] HAVING Count(*)>1 )))
 
Back
Top