Duplicates

[Guest]

Is there an easy way to check for duplicates on a access database??

 

[ChrisM]

Do you mean duplicate records?

Assuming you do,

 

[ChrisM]

Do you mean duplicate records in a table?

Assuming you do,

Is somthing like

SELECT KeyField1, Keyfield2, Count(1) as DuplicateCount
From MyTable
GROUP BY KeyField1, KeyField2
HAVING Count(1) > 1;

Any good??

Where KeyField1, KeyField2 are the fields where your interested in the
duplicates...

Cheers,

Chris.