>>Hi everyone
>>
>>How can I detect the repeated records in a table ?....
>>
>>Thanks in advance
>>Carlos Burgos
>
>Basically a SELECT, with a GROUP BY clause.
>
>If your primary key is called PKField, the code would be something like this:
>
>
>select PkField, count(*) as HowMany;
> from MyTable;
> group by PkField;
> having HowMany > 1
>
If you have duplicate PK, it would not be PK anymore :)
I would guess we need to find duplicates in the rest of the fields, which would make the task much harder, especially if we also want to check Memo fields for duplicity.
If it's not broken, fix it until it is.
My Blog