each record I have has 18 fields, and all but 2 of them can be duplicated many times. I would like to create a query that deletes any records that have both of these fields with the same combination of values.
field one has 254 possible values and field two has 8 possible values. If two or more records were to be a match of field one and field two, I would like it deleted.
How would I go about doing this? Once this query is run, Im planning to make a multifield primary key that will prevent me from entering a sequence of duplicates. It wont let me create the key now, as I must have duplicates.