Access query to select multiple records with matching field
Select [FirstName], [Surname], [Age]
From People
Where DCount("Surname", "People", "Surname='" &amp; SurName &amp; "'") &gt; 1


OR

Select P.*
From (Select Surname From People Group by Surname Having Count(*) &gt; 1) AS G
JOIN People AS P ON P.Surname = G.Surname