Hi Alice,

Create a query, add the fields without any criteria, change to SQL view and amend the script to
SELECT Distinct ....


--
HTH
Bernd


"Alice Dawson" wrote:

I have a table: [Related Submissions]
Fields: Autonumber (Primary key), [SUbmission Number 1], [Submission Number 2], Relationship
Using Access 2002

I want to remove duplicate records where for two records, [Submission number 1], Submission Number 2] and Relationship are the same. It is easy to find the duplicates, but is there any way to remove one of the duplicate records?

Thanks

Alice