title: Does ms access group by order the results?
body: <p>I need to run a query that groups the result and orders it. When I used the following query I noticed that the results were ordered by the field <code>name</code>:</p>
  
  <pre><code>SELECT name, count(name) 
  FROM contacts 
  GROUP BY name 
  HAVING count(name)&gt;1 
  </code></pre>
  
  <p>Originally I planed on using the following query:</p>
  
  <pre><code>SELECT name, count(name) 
  FROM contacts 
  GROUP BY name 
  HAVING count(name)&gt;1
  ORDER BY name
  </code></pre>
  
  <p>I'm worried that <strong>order by</strong> significantly slows the running time.
  Can I depend on ms-access to always order by the field I am grouping by, and eliminate the <strong>order by</strong>?</p>
  
  <p>EDIT: I tried grouping different fields in other tables and it was always ordered by the grouped field.</p>
  
  <p>I have found answers to this question to other SQL DBMSs, but not access.</p>