Change the type of join in a query (MDB)

Microsoft Office Access 2003

previous page next page

Show All Show All

Change the type of join in a query (MDB)

  1. Open a query in Design view.
  2. Double-click the join line between the field lists for the tables or queries.

    Double-click the join line to open the Join Properties dialog box

    Callout 1 Join line

  3. In the Join Properties dialog box, click the join option you want, and then click OK.

Note  From the Relationships window, you can change the default join type for tables.

previous page start next page