Limit to number of levels of nested sub-queries?

P

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
 
D

Dennis

The limit is 50

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

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
Click to expand...

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Fields Nested Too Deeply" Error in Simple Word Document 5
Page numbering with Merged Document and IF statements 1
Inconsistent formatting of section numbers 0
How do I access multiple records within a query? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query Too Complex 8
Filtering a sub-query (back-end is MS SQL) 1
Level resource allocation error 1

Top