title: MS-Access -> SELECT AS + ORDER BY = error
body: <p>I'm trying to make a query to retrieve the region which got the most sales for sweet products. 'grupo_produto' is the product type, and 'regiao' is the region. So I got this query:</p>
  
  <pre><code>SELECT TOP 1 r.nm_regiao,  (SELECT COUNT(*)
          FROM Dw_Empresa
          WHERE grupo_produto='1' AND 
          cod_regiao = d.cod_regiao) as total 
  FROM Dw_Empresa d
  INNER JOIN tb_regiao r ON r.cod_regiao = d.cod_regiao ORDER BY total DESC
  </code></pre>
  
  <p>Then when i run the query, MS-Access asks for the "total" parameter. Why it doesn't consider the newly created 'column' I made in the select clause?</p>
  
  <p>Thanks in advance!</p>