Query is too Complex

[Al V]

I have a query that has about 15 calculations, each
calculation adds or subtracts the other calculations. So
the last calculation has 15 fields which it is summing.

I get the message "Query is too Complex". Is this a
setting I am missing? This is not that complicated, I
cannot imagine that Access cannot handle this.

Please help, as I am under the gun here and do not want to
reinvent and add more queries.

Thanks in advance.

Al

 

[John Vinson]

I have a query that has about 15 calculations, each
calculation adds or subtracts the other calculations. So
the last calculation has 15 fields which it is summing.

I get the message "Query is too Complex". Is this a
setting I am missing? This is not that complicated, I
cannot imagine that Access cannot handle this.

Please help, as I am under the gun here and do not want to
reinvent and add more queries.

Thanks in advance.

Al

The QTC error arises when the *compiled* query exceeds 64KBytes. It
can also occur erroneously when you have a syntax error (such as a
date being interpreted as a division operation, curable by delimiting
the date with # - e.g. #7/27/2004# instead of 7/27/2004).

Note also that you often cannot do a calculation using previously
calculated fields - you may need to go back to the original fields
rather than basing a calculated field on intermediate calculations.

Perhaps you could post the SQL of the query, someone might see a way
to do it more simply!