D
Dale Fye
I am running Access 2000(SP3) on an XP operating system.
I have a query (Query4) that is currently running correctly. It is actually
based on three other saved queries (Query 1 joins about 8 tables to pull in
all the fields I need for my analysis; Query 2 performs a union query on two
copies of Query1 to normalize the result set; Query 3 takes the results of 2
and groups by several of the fields and aggregates several other fields).
Query4 takes the results of Query3 and aggregates it on several other fields,
and does some division to get percentages.
When I try to modify Query4 in any way, or create a new query with exactly
the same syntax, I get this "Query is too complex" error message.
Any ideas how to get this to work?
I have a query (Query4) that is currently running correctly. It is actually
based on three other saved queries (Query 1 joins about 8 tables to pull in
all the fields I need for my analysis; Query 2 performs a union query on two
copies of Query1 to normalize the result set; Query 3 takes the results of 2
and groups by several of the fields and aggregates several other fields).
Query4 takes the results of Query3 and aggregates it on several other fields,
and does some division to get percentages.
When I try to modify Query4 in any way, or create a new query with exactly
the same syntax, I get this "Query is too complex" error message.
Any ideas how to get this to work?