I have a table in ms access that has duplicate records.
The duplicates can only be identified by two fields.
The record is a duplicate if it has the same value in the field "source" AND the same value in the field "source".
This table only has 3 fields. The other field is the "sourceid", which is the primary key and an autonumber.
How can I automate the process for deleting the duplicate data?
Any suggestions are welcome and appreciated.
The duplicates can only be identified by two fields.
The record is a duplicate if it has the same value in the field "source" AND the same value in the field "source".
This table only has 3 fields. The other field is the "sourceid", which is the primary key and an autonumber.
How can I automate the process for deleting the duplicate data?
Any suggestions are welcome and appreciated.