A data table, made of access, encountered the problem duplicates,
Figure of M, V, N three repeated determination for duplicates, delete duplicates how to do?

CodePudding user response:

Find out the same value ID first, and then choose MIN or MAX maximum ID when you delete
The select conditions from table
Group by condition
Having (count (*)) & gt; 1