Create a Multiple Table Query

How to Create a Multiple Table Query in Access

Create a Multiple Table Query

Create a Multiple Table Query

Just like it sounds, a multiple-table query blends together information from two or more related tables. The main difference between a multiple-table query and a single-table query is that with multiple-table queries, Access creates a link between related tables.

  1. Click the Create tab on the ribbon.
  2. Click the Query Design button.
    Create a Multiple TableQuery
  3. Double-click the tables or queries you want to use and click Close.
    Create a Multiple TableQuery
  4. If two tables are related, Access will automatically connect their common fields with a join line. If the tables aren't related you will have to manually join the tables by dragging a field from one table's field list to the matching field in the other table's field list.

  5. If necessary, join the fields between tables.
    Create a Multiple TableQuery
  6. To remove a join line, click the join line and press Delete.

  7. Double-click each field you want to include in the query.
  8. You can also add fields to a query by dragging the field from the field list onto the design grid.

    Next you need to specify any criteria for the query.

  9. Enter any search criteria for the field.
  10. Click the Save button.
    Create a Multiple TableQuery
  11. Enter a name for the query, and click OK.
  12. Click the Run button.
    Create a Multiple TableQuery

Access displays the results of the query.

FREE Quick Reference

Click to Download