Grouping from a sub-query

C

Chris

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?
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Shared Link is showing empty notebook 1
Multi-Selection with Hand-writing draw tool 0
DCount within a Group 2
Publisher is filling blank lines with data 2
Counting Records in A Group 5
Handling & comparing old vs new data 0
SELECT MAX(value) from table1 and add several associated values from table2 10

Top