Query is too complex... On report, but query runs fine

[Canderel]

Hi...

I have a query that when I run it normally (just click on it) then it runs fine. (It is a union query, getting it's data from 8 other queries (who has their dependancies)

But when I want to run a report from it, Access gives me an error saying "query is too complex".

I am flattered, but I would prefer access to work than say I write stuff that is too complex for it.

Any ideas?

I am confused by the fact that it runs when I double click the query, but the report bugs it out.

-Reenen

 

[Jon K]

Try building a temporary table from the Union query and basing the report on the temporary table.

Make-table Query:
Select * into [TempTable]
From [yourUnionQuery]
.