Grouping from a sub-query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report from a query where the queryranks and
generates scores. I want the report to group on students' names (one page
per student). However, when I try to group on student name in the report, it
states "Multi-Level Group by Clause is not Allowed in a Subquery." How do I
get around this?
 
Yes, it's very easy to run into this problem using a subquery in the source
for a report.

One workaround is to use a stacked query instead of a subquery. That is,
break the subquery out into its own query and save it. Then use it as an
input "table" for the main query that feeds the report.
 
Back
Top