title: Count distinct query MS Access
body: <p>It seems that we can not use <code>Count (Distinct column)</code> function in MS Access. I have following data and expected result as shown below</p>
  
  <p>Looking for MS Access query which can give required result.</p>
  
  <p>Data</p>
  
  <pre><code>ID     Name     Category    Person  Office
  1      FIL       Global     Ben     london
  1      FIL       Global     Ben     london
  1      FIL       Overall    Ben     Americas
  106   Asset      Global     Ben     london
  156   ICICI      Overall    Rimmer  london
  156   ICICI      Overall    Rimmer  london
  188   UBS       Overall     Rimmer  london
  9    Fund      Global       Rimmer  london
  </code></pre>
  
  <p>Expected Result</p>
  
  <pre><code>Person  Global_Cnt  Overall_Cnt    
  Ben          2         1
  Rimmer       1         2
  </code></pre>