Parameters

C

CorporateQAinTX

What is the limit for how many parameters can be considered in a query?

I got an error message "Query Too Complex". I'm guessing that means I need
to trim it some. But I'd like to know how far I can go in the future.

Thanks ahead of time....
 
J

Jeff Boyce

Have you checked Access HELP for "specifications"? It may list that limit
there.

I seem to recall that factors other than/in addition to the number of
parameters can affect the "complexity".

What happens when you "trim" it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
C

CorporateQAinTX

I couldn't find a listing in the HELP documents. I always try that first. By
trimming, I mean reducing the number of parameters. Not using the "Trim"
function.

Thanks for the help anyway.
 
J

Jeff Boyce

When I start getting that error message, I do something similar ('trim', not
"Trim()" <g>).

I've even gone all the way back to the beginning and created a "base" query,
then "chained" a second query based on the first, then a third on the
second, etc, adding criteria/parameters as I chain. This can reduce the
"complexity" of a single query.

Consider posting the SQL statement of your query to give the newsgroup
readers a chance to spot something...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top