Limit to number of levels of nested sub-queries?

[PatrickM]

Is there a limit to the number of levels of nested sub-queries that a query
can have? I've built queries with at least 10 levels and they've worked
fine, and am wondering where the limit is if there is one.

Thanks,
Patrick

 

[Dennis]

The limit is 50

Look in help under microsoft access specifications for list of all maximums

 

[PatrickM]

Thanks Dennis.

Patrick

The limit is 50

Look in help under microsoft access specifications for list of all maximums

 

[John W. Vinson]

Is there a limit to the number of levels of nested sub-queries that a query
can have? I've built queries with at least 10 levels and they've worked
fine, and am wondering where the limit is if there is one.

Thanks,
Patrick

You'll probably reach the "Query Too Complex" limit first - it is triggered
when the compiled query exceeds 64KBytes.

The need to nest subqueries that deeply makes me curious about your database
design!