title: Access: Use scalar correlated subquery result for sorting
body: <p>In Access, is it possible to use the result of a scalar correlated subquery to sort the resultant rows?  This didn't work (returned a sql error):</p>
  
  <pre><code>SELECT (SELECT MIN(DateTime)  FROM Appt WHERE  (PatientID = XXX.ID)) AS minDT, XXX.FullName, 
  FROM Patient AS XXX
  ORDER BY minDT;
  </code></pre>
  
  <p>Replacing the "minDT" in the <code>ORDER BY</code> clause with the entire expression didn't work either.</p>