Query, find duplicates

[gmaster]

Hi! I have a tab with "Name" and "Surname" fields among others. And i'm struggling in the easy task of writing a query that can find all the records with the same name and surname....Ideas?
Thanks!!

[gmaster]

Ok, solved on my own
Thx anyway!

[lfpm062010]

Try, if the table name is "TABLENAME" with field "NAME" and "SURNAME".

SELECT TABLENAME.NAME, TABLENAME.SURNAME
FROM TABLENAME
WHERE TABLENAME.NAME = TABLENAME.SURNAME;