title: Sql unequal data sets in a access-table
body: <p>I'm working since two weeks on a VBA-Application in Access 2016. For this I need to purge a Table on inconsistent data sets. To find out which Datasets are inconsistent, I need a SQL-query. So my Table looks like this:</p>
  
  <pre><code>ID        Description      User           Comment              Date
  
  1         Example1         sht3454        This is a comment     10/17/2017
  1         Example2         sht3454        This also             10/15/2017
  2         Example3         hdjfur198      ;)                    10/11/2017
  </code></pre>
  
  <p>I have to find out which Datasets are inconsistent, in my Example the Datasets with the ID 1 because they have a different Description.
  The Tablefield ID is in this example no primary key.
  I thought about something like  </p>
  
  <p><code>SELECT Count(ID), Description From DB_Data  group by ID,Description having (count(ID) &gt; 1)</code> </p>
  
  <p>but it is not the solution of my Problem.
  Do someone of you have an idea for this?</p>