Linking 2 queries?

[mcfly]

Ok I have a query that is pulling information from linked tables from our data entry software.
http://www.notafinga.com/Screen1.bmp

I also have another query that is doing the same thing but has a different relationship.
http://www.notafinga.com/screen2.bmp

I am importing this information into excel using the import data feature. However I am only able to use the first query and not both of them for the different results.

What I need to know is can I link the 2 queries in access so that I can get both of the results that I need?

 

[Norie]

Can you not just add the queries to a new query in the same way you add tables?

 

[texasalynn]

to link you will need to have a common field in both. Otherwise you will have to build a table that will build a common field.

HTH
texasalynn