title: MS Access How do I query the results of another query
body: <p>I have an existing query (Query1) that returns 5 fields from a table. What I want to do is then have another query (Query2) that uses each record from one of the fields returned in Query1 to return fields from a different table. Both tables have a common field (Project). Query1 returns Project and 4 additional fields. For each record returned by Query1 I want to run Query2 based on the Project field. How do I design Query2?</p>
  <p>Thanks in advance for your help!</p>