title: How to delete duplicate values in a column in MS Access via SQL or VBA
body: <p>Is there any kind of VBA or SQL which i could run on this table which delete duplicate ID's within MS Access? </p>
  
  <p>So this:</p>
  
  <pre><code>ID          data1   data2   data3   
  a           1       2       3   
  a           8       9       10  
  a           15      16      17  
  a           22      23      24  
  b           1       2       3   
  b           8       9       10  
  b           15      16      17  
  b           22      23      24  
  b           29      30      31  
  c           1       2       3   
  c           8       9       10  
  c           15      16      17  
  c           22      23      24  
  c           29      30      31  
  c           36      37      38  
  </code></pre>
  
  <p>Would look like this :</p>
  
  <pre><code>ID      data1   data2   data3   
  a        1      2       3   
           8      9       10  
           15     16      17  
           22     23      24  
  b        1      2       3   
           8      9       10  
           15     16      17  
           22     23      24  
           29     30      31  
  c        1      2       3   
           8      9       10  
           15     16      17  
           22     23      24  
           29     30      31  
           36     37      38  
  </code></pre>