I have 2 very complex queries (many Union Selects in each one) and after so much coding Access tells me that the query is too complex. So I split the query into 2 separate ones. Now I want to be able to call both queries (I'm thinking from a third query) and have the results of both queries combined into one result set. Is that possible and if so how would I do that ?