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.

    Query wizard

  4. In the Available Fields pane, click the first field you want to use in the query and click right-arrow button. 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 in Join tables and queries.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!