title: Microsoft Access Query to SUM & SORT in a query
body: <pre><code>SELECT ptMeds.Station, ptMeds.TxDate, ptMeds.PaType, ptMeds.GenMedName, 
  ptMeds.Strength, ptMeds.UnitsM, ptMeds.Volume, ptMeds.Dosage
  FROM ptMeds
  WHERE (((ptMeds.Station)="EMER1") AND ((ptMeds.PaType)="WITHDRAWN")) &lt;I will need to look at the GenMedName field here also&gt;
  GROUP BY ptMeds.GenMedName;
  </code></pre>
  
  <p>I need to be able to SUM based on ptMeds.GenMedName and then sort the results highest to lowest.  I've looked thru other responses to similar question but cannot find exactly what I need to do.  Any help would be greatly appreciated.</p>