Hi My query has 3 columns, 'PCD,' 'Reference' and 'Code'. PCD

[Richey]

Hi
My query has 3 columns, 'PCD,' 'Reference' and 'Code'.

PCD Ref Code
CH4 2HX 85 T
CH4 2HX 79 T
CH3 1BU 75 F
CH3 1BU 102 T

I would like a query that says if PCD is the same and the code is the same then delete the rows, but if PCD is the same and the Code is different do not delete the rows, so in this example I'd be left with

PCD Ref Code
CH3 1BU 75 F
CH3 1BU 102 T

Help would be much appreciated
Regards
Richey

 

[alley]

Richey,

Use the Find Duplicates Query, and use the results to delete them with a delete query.

Do the dupes query first, and look at the table vue to verify the selected records.
Then do a delete query, calling the dupes query as the source.

alley