Query to show only duplicate records (2003)

Topic

New Reply

I need to produce a query to show only duplicate records, see attachment records highlighted in red are those l want to show in result of query. Any help would be appreciated.

Reply | Quote

Replies

Group by that filed add a second instance of the field and use a count summary and use a criteria aof >1

Reply | Quote

That works great thanks

Reply | Quote

assuming your tabel is called table1 and the field is called field1, the following SQL statement should do it:

SELECT DISTINCT table1.field1 FROM table1 INNER JOIN (SELECT field1 FROM table1 GROUP BY field1 HAVING COUNT (*) >1) as Tbl1 ON table1.field1 =Tbl1.field1;

Reply | Quote