Query is too complex (run-time error)

  • Thread starter Thread starter Sotiris
  • Start date Start date
S

Sotiris

I have a report with an underlying query which is rather
complex. The query by itself runs just fine, however the
report does not, producing the run time error that the
query is too complex. If I remove some controls from the
report is works.

It seems that the combined SQL statement from the query
and the report is too complex to be handled by Access.

- Are there any documented limits for the SQL statements?
- Any ideas about how to get around this problem except of
making a make-table query and then base the report on the
table?

Thanks.
 
Historically, queries were 'too complex' if the
query analyser ran out of memory (originally, 32-64K)
Even though it is documented, it is not any use to
know.....

Since the query analyser may take a different path
through the query, any change to the query may solve
or create this problem.

However, be sure that it is not too complex just because
you have misnamed controls or bad data.

(david)
 
Back
Top