Chat with us, powered by LiveChat

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 Table Query
  3. Double-click the tables or queries you want to use and click Close.
    Create a Multiple Table Query

    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.

  4. If necessary, join the fields between tables.
    Create a Multiple Table Query

    To remove a join line, click the join line and press Delete.

  5. Double-click each field you want to include in the query.

    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.

  6. Enter any search criteria for the field.
  7. Click the Save button.
    Create a Multiple Table Query
  8. Enter a name for the query, and click OK.
  9. Click the Run button.
    Create a Multiple Table Query

Access displays the results of the query.

FREE Quick Reference

Click to Download