Getting Query is Too Complex ERROR Messages

[sportsguy]

I am now getting the "Query is Too Complex" error with a query, which has a union query which is attached to other tables, AS SOON AS a criteria is added to any field.

As far as I can recall, and over 50, its hard to recall yesterday,
I don't remember getting QiTC error messages with criteria applied in a query of a union query.

Am I missing something? if so, this means that I need a union query for each report as each report has a criteria requirement. . .. ugh!

thanks

sportsguy (not a noob! though i might type or read like one!)

 

[georgedwilkinson]

Can't you just query the query that is not too complex and add your criteria in the "outer" query?

 

[sportsguy]

that's the design , the union query works fine.

i put the union query and any criteria in the second or outer query,
and I get the QiTC error message. . . I used to be able to do this,
or I have done this before, but in A2000.

In A2003, i am not having fun. . .

is this phenomina just related to sportsguy?

thanks

 

[neileg]

Three thoughts
1) A2003 has a problem with SP3 which requires a 'hotfix'. So either apply SP1&2 but not 3, or apply all 3 plus the hotfix.
2) Union queries can often be indicative of a design problem. Should the data not live in one table?
3) In desparation, when 'fixing' a database I didn't design, I have resorted to a MakeTable based on a Union and queried the table.

 

[ajetrumpet]

Can't you just query the query that is not too complex and add your criteria in the "outer" query?

Talk about a tongue twister!!!

 

[tranchemontaigne]

Sometimes this error message is generated if the query length contains too many characters and the semicolin is truncated from the end of the query at run time.

You might want to save the output of each section of the UION query to a separate query, then write your UNION query something like this to overcome string length limitations

SELECT
*
FROM
qryFirst

UNION
SELECT
*
FROM
qrySecond

UNION
SELECT
*
FROM
qryThird
;

Hope this helps
________
CHEVROLET SS

 

[sportsguy]

thanks neileg

that reply makes the most sense, since i have been writing them previously, and never ran into this problem before

sportsguy