In Access I have made two query: 1) Query1- a subquery 2) Query2 - that use first subquery Is there a way to automatically combine the SQL code of those two queries in Access, so there will remain only one query?