Basic ? on Duplicate Search

[aldipalo]

I have a DupCalc key 'CompanyName&LastName&FirstName'. When I enter a'!' in the DupCalc field and get e.g. '200' records. Are they all the dups or are they the original and the dup? The reason I ask is sometimes there is only one record rather than 2 or 3. Should I be deleting the whole found set or every other record?

Thanks

[mr_vodka]

Doing a search with a ! will return only those with duplicate records.

IOW, lets say you have a table with the following records.

1

2

3

2

4

5

3

6

7

3

It will return

2

3

2

3

3

[comment]

See also:

Comparison of methods to remove duplicate records

[aldipalo]

Thanks guys. I think I got all the dups out, but, was just concerned that my search showed some single returns. I have used something similar to the files you posted and they were extremely helpful.

Al