duplicate records

[thedee23]

Does anyone know of a good way to get only duplicate fields in a Access database using a sql statement? For example - If I have a field in my table called Last Name and I want to get all the records with duplicate Last Names. What would be the best way to get this info?

[JHausmann]

select lastname, count(lastname) from table group by lastname having count(lastname)>1