Query Too Complex Error on MS Access

Asked By bellaross 0 points N/A Posted on - 10/26/2011

I am trying to produce a certain report using MS-Access but I am getting an error, “Query Too Complex”. When I try to run the query of the report, it is working perfectly fine. Why am I receiving error when trying to generate the report?

  Help please.

• Status: Open
• Question Views: 995
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By maverick 0 points N/A #94610

Query Too Complex Error on MS Access

Hi Bellaross,

The problem that you might be encountering is the allowable kilobyte segment.  Access require that queries made must be complied within the 64 kb segment. When running reports they create temporary queries and are then combined which should not exceed the 64kb limit.

You can try to shorten the table names, etch, remove the fields that you do not need on the report. Avoid or remove stacked query object.  You can also use instead small reports then just combine them into one major report.

You can also build a temporary table and update it with the required fields for your report and make a simple query from there.

About maverick

Questions
0

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: MS Access