Create a Query That Uses Two or More Tables

Create a Query That Uses Two or More Tables

If you want to view data from two or more tables or queries, you can create a query that pulls the data from multiple tables or queries. The tables and queries from which you pull your data

  Should have a relationship.

To create a query that uses two or more tables:

1.   Open the tables and/or queries you want to use in Query Design view.

2.   Choose the field names you want to retrieve in the order you want to retrieve them.

3.   Choose the field names you want to sort by in the order you want to sort. Under the fields you want to sort by, choose Ascending or Descending.

4.   Enter your selection criteria, if necessary (Not applicable in this example).

5.   Deselect the Show button for columns you do not want to display (Not applicable in this example).

6.   Click the Run button. Access retrieves the columns you chose and displays the rows in the order you specified.

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati