title: SQL Sorting of Grouped Data
body: <p>I'm looking for a way to return data in a very specific order from an Access database using SQL. I want look for the lowest frequency, list all systems in frequency order starting with the system of the lowest frequency, then do the same operation on the next highest frequency and so on.</p>
  
  <p>This is how I would like the output to be. (The line breaks are just for ease of seeing the sort order, I will add those in the program code later.)</p>
  
  <pre><code>System   Freq
  ------  ------
  FM        100
  FM        120
  FM        150
  
  AM        110
  AM        150
  AM        170
  
  CW        160
  CW        180
  CW        200
  </code></pre>
  
  <p>Is something like this possible with SQL? Any help would be greatly appreciated. Thank you. </p>