union query says "System resources exceeded"

[Keifer]

I have other union query's that work and this one did work but now I can add
2 quer's together but not 3. I mcan add any 2 but not 5.

 

[John W. Vinson]

I have other union query's that work and this one did work but now I can add
2 quer's together but not 3. I mcan add any 2 but not 5.

Please post the SQL of the query. We can't fix what we can't see. And I have
NO trace of an idea what your last sentence means.