tech on the net

MS Access: Add tables to a query in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, I've created a query and I want to add another table to the existing query. How do I do this?

Answer: To do this, open the query in Design view. Select the Design tab in the toolbar at the top of the screen. Then click on the Show Table button in the Query Setup group.

Microsoft Access

When the Show Table window appears, highlight the table that you want to add and click on the Add button. When you are done selecting the tables, click on the Close button.

In this example, we want to add the Order Details table.

Microsoft Access

You should now see the Order Details table appear in the Query window.

Microsoft Access