title: Access SQL-Query ORDER BY Alias-Column
body: <p>I have a question about a simple sql-query.</p>
  
  <p>This is my query in Access 2013:</p>
  
  <pre><code>SELECT Shippers.Shipper_ID, Shippers.ShipperName, SUM(Orders.TotalPrice) AS TotPr FROM Orders
  LEFT JOIN Shippers
  ON Orders.Shipper_ID=Shippers.Shipper_ID
  GROUP BY Shippers.Shipper_ID, Shippers.ShipperName
  ORDER BY Shippers.ShipperName;
  </code></pre>
  
  <p>... and it work perfect. But how can I put the alias-column (TotPr) in ORDER BY?</p>
  
  <p>Thank you for help :)</p>