title: Count(Distinct FieldName) in access query
body: <p>I am trying to write a query in Ms access 2010 but it is not allowing Count(Distinct OrderID) syntax in there which I am easily able to write in oracle.</p>
  
  <pre><code>Select BrandID, Count(Distinct OrderID), Count(Distinct ModelID)
   From ordertable
     Where Trunc(Pur_Date) Between '01-Feb-2015' And '09-Feb-2015'
  Group By BrandID
  Order by BrandID
  </code></pre>
  
  <p>Table structure:</p>
  
  <pre><code> OrderID  BrandID  ModelID
     1        abc      a
     1        abc      b
     1        abc      c
     2        def      f
     3        ghi      a
     3        ghi      c
     4        abc      g
     4        abc      b
  </code></pre>
  
  <p>Please help in achieving this.</p>