title: Sorting a grouped report
body: <p>My schema looks a bit like this:</p>
  
  <pre><code>SEQ  GROUP1  GROUP2  GROUP3  VALUE
  </code></pre>
  
  <p>Where <code>SEQ</code> is roughly equivalent to the row number -- it's actually sort order, from an external table -- and the <code>GROUPx</code> fields delineate the data further. So, for example:</p>
  
  <pre><code>SEQ  GROUP1  GROUP2  GROUP3  VALUE
  ---- ------- ------- ------- ------
  1    A       A       A       123
  2    A       A       A       456
  3    A       B       C       foo
  5    X       Y       Z       bar
  4    A       B       D       baz
  </code></pre>
  
  <p>I would like this data grouped in this hierarchy, but ordered by <code>SEQ</code>. So, the above data would produce a report like:</p>
  
  <pre><code>A
    A
      A
        123
        456
    B
      C
        foo
      D
        baz
  X
    Y
      Z
        bar
  </code></pre>
  
  <p>I've been playing with the "grouping and sorting" options of the report and I seem to be able to have it ordered but not grouped, or grouped but not ordered!</p>
  
  <p>For example, if I specify:</p>
  
  <ul>
  <li>Group by <code>GROUP1</code>
  <ul>
  <li>Group by <code>GROUP2</code>
  <ul>
  <li>Group by <code>GROUP3</code>
  <ul>
  <li>Order by <code>SEQ</code></li>
  </ul></li>
  </ul></li>
  </ul></li>
  </ul>
  
  <p>The values in the grouping level fields determine the order in which the data comes out. (In this case, the names I've chosen are in alphabetical order anyway, but if I changed the name of <code>X</code> in <code>GROUP1</code> to <code>123</code>, it would appear right at the top of the report.)</p>
  
  <p>If I move the "Order by <code>SEQ</code>" to the highest priority, the order is correct, but the grouping levels are broken: Access basically treats the <code>SEQ</code> field as a grouping level and then the subsequent hierarchy is repeated for each value in that group.</p>
  
  <p>Is there any way I can achieve what I'm looking for without having a <code>SEQx</code> field for each <code>GROUPx</code> field (rather than my current "global" <code>SEQ</code>)?</p>