This is just for my own reference. You have this DB where you develop many queries. How does access determine which of the queries it executes upon first..second..and so on or does it? Say you have 3 queries. The second query is designed solely on the results of the first and the result of the third is based upon the second. Without using a DoCmd OpenQuery, how does access know which query needs to executes in the proper sequence?