Multi level Group By clause not allowed in subquery

  • Thread starter Thread starter Olavious
  • Start date Start date
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
 
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
 
Back
Top