A newbie question:
I know you can query a query, but how many levels of queries can you do?? For example, can I do a union query on several queries, which some of them may be based on a query, and then do a query on the union query?

Thanks for any comments!

the answer is it depends...the max number of nested queries is 50 and a max of 32 tables.

but you may take performance hits before the maximum number is reached. you also may encounter 'too complex to evaluate' errors.

i have done some pretty deep nesting with no problems and good performance.

i'm not sure how much union queries impact this.

best advice is to try it... http://www.access-programmers.co.uk/ubb/smile.gif

hth,
al