Add tables to a new query

Most queries use multiple tables, queries, or a combination of the two as the record source. The Query Wizard is the easiest way to build multi-source queries.

When using multiple tables, make sure that they are related. Learn more about creating related tables.

1. Click the Create tab, click Query Wizard.

2. Select Simple Query Wizardand click OK.

3. In the Tables/Queries list and click the first table you want to use.

   
   

4. In the Available Fields pane, click the first field you want to use in the query and click . Repeat to add other fields from that table to the Selected Fields pane.

5. Open the Tables/Queries list and select the second table or query.

   Important:  The tables you use in this type of query must participate in a relationship, either directly or indirectly.

6. Repeat step 4 to add fields from the second table and click Next.

7. When you are done adding fields, enter a name for the query and click Finish.

See how to limit the number of items in a query with multiple tables by using joins.