>I want to create a primary index on my table based upon a combination of two fields. It has 2960 records. I ran a query on it with no duplicates checked it appears to have 12 dups of this combination. Whats the best way to find the dups so I can clean them up. There is no reason for the dups. Thanks.
>
>God Bless,
>S Dyke
The best way is to use a surrogate key rather than a combination of fields. See the KB article on my web site for more details and a routine that works.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer