the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE
I am a little confused because in your question is the answer. To combine the results of two queries into one query you use a Union query. The thing to remember is that each query has to have the same number and order of fields for a Union query to work properly.
If, on the other hand, that you need to combine two queries into one table, then you can create a table design, then convert the two queries into Append queries. Or make on query a Make Table query and the other one an Append query.