Multi level Group By clause not allowed in subquery

O

Olavious

I receive this error message when trying to build a report on a query which includes subqueries.

Any trick how to use a subquery in a report with detailed sorting and grouping ?

Thank you for your help

Olaf
 
A

Allen Browne

Yes, this is quite common with reports.

Any possiblity of using another query as an input "table" to your main
query? That would avoid the need for a subquery, whcih avoids the problem.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I receive this error message when trying to build a report on a query which
includes subqueries.

Any trick how to use a subquery in a report with detailed sorting and
grouping ?

Thank you for your help

Olaf
 

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

Multi-Level GROUP By Clause is not allowed in subquery 4
Multi-level Group By Clause is not allowed in a subquery 4
Multi-level GROUP BY clause is not allowed in a subquery? 2
Multi-level GROUP BY clause not allowed in a subquery 3
Multi Level Group by clause 1
Referring to fields in a subquery 1
SubQuery 1
Multi-level GROUP BY 6

Top