title: COUNT DISTINCT MS ACCESS
body: <p>I have a table called "orders"</p>
  
  <pre><code>clientID |  order_status
  client1  | pending  
  client1  | shipped
  client2  | pending  
  client2  | complete 
  client3  | complete  
  client3  | shipped
  client4  | pending  
  client4  | pending 
  client5  | shipped  
  client5  | shipped 
  client6  | complete  
  client6  | complete  
  </code></pre>
  
  <p>I want to select any clientID that has records with order_status of both "pending" and "shipped"</p>
  
  <p><b>This example should return only "client1"</b></p>
  
  <p>Here is my query:</p>
  
  <pre><code>SELECT clientID  
  FROM orders  
  WHERE order_status IN("pending", "shipped")  
  GROUP BY clientID  
  HAVING COUNT(*) &gt; 1
  </code></pre>
  
  <p>Which returns:</p>
  
  <pre><code>client1
  client4
  client5
  </code></pre>
  
  <p>I know I need to use <b>COUNT (DISTINCT order_status)</b> but this is a Microsoft Access Database and I'm not sure how to implement it properly</p>