title: Access SQL using TOP 5 returning more than 5 results?
body: <p>I'm using the following statement</p>
  
  <pre><code>SELECT TOP 5 rootcause, COUNT(IIF(accountability="Team 1",1,0))
  FROM  MOAQ
  WHERE CDT=1
  GROUP BY rootcause
  </code></pre>
  
  <p><code>MOAQ</code> is another query that returns about 20 fields from 4 tables, nothing special.  This works as expected and I get 5 results.</p>
  
  <p>If I add an <code>ORDER BY</code> clause on the conditional field though I start to get 8 results.  If I sort by the first field there is no problem.</p>
  
  <p>Anyone know what might be going on?</p>
  
  <p><strong>Edit to clarify</strong> - I am only testing from within Access 2003 at this point, eventual statement will be parameterized query via ADO from Excel front end.</p>