Duplicate Query

[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 )

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

 

[P Brainard via AccessMonster.com]

To clarify:

If dupe SSN and first name is different, then exclude from results.

 

[Roger Carlson]

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 )))