Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!