title: how do I do a count distinct group by in ms access?
body: <pre><code>SELECT [dataset].[ID], count(distinct([dataset].dates)) AS distinct_dates
  FROM [dataset]
  GROUP BY [dataset].[ID];
  </code></pre>
  <p>this gives the error <code>UnDefined function Distinct in expression</code></p>