|
RemoveDuplicates.mdb (beginner) |
||||
Please consider donating $1 per sample downloaded, find out why here |
Download RemoveDuplicates.zip Access 97 (74 KB) |
Illustrates a method for removing duplicate records from a table. 1) If the table does not have a primary key, add an autonumber field. It is essential that the table have a unique field. For example, copy Chains table, add a field called ChainID and make it an autonumber and the Primary Key. 2) Create a delete query like qdelRemoveDuplicatesFromChains2: DELETE * FROM Chains2 AS E WHERE E.ChainID > (SELECT MIN(X.ChainID) FROM Chains2 X WHERE E.Chain = X.Chain); 3) Run the delete query/ |
||||
|
|||||
|
|||||