Hello I would like to use the result of two different queries in a new query, I tried using a union query but it combined the answers of the original queries which is not what I was aiming for. Help please?
You should be able to create a new query and use an existing query as the source. Just reference the existing query the same way you would if you were using a table as the source.