>>What is the best method to identify duplicate records in a table?
>>In this case there is approx 1.5 million records and i need to look at
>>each field.
>>
>>your help will be appreciated.
>Do you mean duplicate as in all fields are duplicated or as in certain fields are duplicated?
ALL fields.