>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
What are the data types of the 2 fields? Combining 2 numeric fields [i.e., field1 + field2] can easily give dupblice sums. 1999 + 20 as the PK in one record is the same as 2000 + 19 in another record. Use a srrogate PK if at all possible, otherwise you should convert the fields to strings in the index expression: str(field1) + str(field2)
Mark McCasland
Midlothian, TX USA