Max number of stacked queries?
Posted on 2003-11-03
I have about six queries stacked in line. i.e. queries within queries...
Is there a maximum number of stacked queries allowed?
I just tried to add another query to the stack, and a simple answer seems un-obtainable. It is a three column query where on of the columns is a tickbox. When I set the criteria on the tickbox column to true, no records are returned. If I clear the criteria, there are records with both true and false returned values from the tickbox column.
This makes me beleive MS Access gives up when the queries are stacked so high.
Any help apprec...