Hi Larry,
This is a quick and dirty sql statement that should get you going:
SELECT DISTINCTROW [Mailing List].FirstName, [Mailing List].LastName, Count([Mailing List].LastName) AS CountOfLastName
FROM [Mailing List]
GROUP BY [Mailing List].FirstName, [Mailing List].LastName
HAVING (((Count([Mailing List].LastName))>1))
ORDER BY Count([Mailing List].LastName) DESC;
I created it with access' query editor. It groups people by lastname+firstname and then counts how many last names are found for each such combination, then filters by rows returning more than 1 existing record.
Alex
Low-carb diet not working? Try the Low-food diet instead!