using subquerys in reports

A

alf

Hi:
I'm using a query with subquerys in the recordsource of a report.
the query alone woks fine but in the report I receive the error:
"Multi-level GROUP BY clause is not allowed in a subquery"
I search in google and I found that the only solution for this is substitute
the subquery with Dlookup but this decrease a lot the performance.
Anybody know any other solutions ???
thanks, alf.
 

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 a subquery 4
Multi-Level GROUP By Clause is not allowed in subquery 6
Sum Function 0
Multi Level Group by clause 1
Set Paramter in Subqueries 2
Totals in report based on query with subquery (as tought by A.Brow 6
Calc field causing data loss in report.... 0
Grouping from a sub-query 1

Top