Query help

[Julie Smith]

Hi everyone,
I want to create a query that finds records that are duplicated. An example
I have is a table, Parts, with three primary keys, partID, partFilename, and
partDirectory (this is just an example, not the actual table I have).

I want the query to show records that are have the same partFilename AND
partDirectory. Sample data (partID, partFIlename, partDirectory):
(1, 1.file, C:\)
(1, 2.file, C:\)
(2, 1.file, C:\)
(3, 3.file, C:\)

The query, when run, should show:
(1, 1.file, C:\)
(2, 1.file, C:\)

Can anyone help?

Thanks very much in advance,

Julie.

 

[David F Cox]

I think the duplicate query wizard will do this,