Multi Level Group by clause

B

BOONER

When I try to run one of my reports, I am prompted with the message
"Multi-level GROUP BY clause is not allowed in a subquery. What does this
mean? Any suggestions on how to work around this?
 
A

Allen Browne

In most reports, you use the Sorting And Grouping dialog to create group
headers and footers, and specify sorting. Behind the scenes, Access handles
the grouping and sorting with a higher-level query into the RecordSource.
This can very easily trigger the "Multi-level GROUP BY" problem.

The workaround is to modify the source query so Access is able to group/sort
the results for the report. Subqueries are a common cause. You may be able
to replace them with a JOIN or other approach. Sometimes stacking a query on
top of another query is enough to work around the problem. Removing
everything from the report's Sorting And Grouping is another (not very
useful) workaround.
 

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

Help with multi-level list 0
Report Group Footer DLookUp 0
Multi-Selection with Hand-writing draw tool 0
Multi-Level GROUP By Clause is not allowed in subquery 6
Automatic Emails sent to my Contact Groups by Microsoft 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Order by Clause 7
Multi-level Group By Clause is not allowed in a subquery 4

Top