title: Sorting rows in cross query Access SQL
body: <p>I have a cross query in Access with an SQL:</p>
  <pre><code>TRANSFORM Tab1.Income AS Income
  SELECT Tab1.Month
  FROM Tab1
  GROUP BY Tab1.Month
  PIVOT Tab1.Group;
  </code></pre>
  <p>Months are string, not a number, and are in alphabetical order. I want to sort them manually.
  In the normal query, I used a Switch() function which works perfectly. But in the cross query I've got an alert that ORDER BY and GROUP BY are mutually exclusive.</p>
  <p>I would be grateful for any idea, how to sort them in query. However, if it's not possible, maybe they can be sorted in the report because this is more important.</p>