Select Name, Count(Name) as Cnt from voters Group by Name Having Count(Name) > 1
SELECT ID,Name,Houseno FROM Voters WHERE (((Voters.[Name]) In (SELECT [Name] FROM [Voters] As Tmp GROUP BY [Name] HAVING Count(*)>1))) ORDER BY Voters.[Name], Voters.[Houseno];
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)