Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find duplicates
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00358922
Message ID:
00358930
Views:
12
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!
Previous
Reply
Map
View

Click here to load this message in the networking platform