Complex Query

[kdm3]

Hi, I find myself in a spot of bother...

I have just written a quite complex query, which is basically a union query based on data from three queries, which in turn are based on multiple queries, calculated expressions and further union queries (it's kinda an involved requirement). I finished, great, all the data in the source queries is fine, so I created the union query and to my dismay was greeted with the message:

System resource exceeded

I broke down the union into two stages, and was then greeted with:

Query is too complex

Is there anything I can do about this?

 

[Len Boorman]

Okay so you are sure that all the source queries are okay. !!

You could convert the 3 main queries into 1 make table query and 2 Append queries.

You then get all the data you would have from a union.

It does sound a bit iffy though on the Union. Test by creating a simple Select query for each element of the Union and make sure that the Select bit works before adding it to the UNION

Len B