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.


    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 by using joins.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×