How to Create Relationships Between Queries in Microsoft Access
- 1). Open a Microsoft Access database with at least two existing queries. The two queries should have at least one field in common. For instance, one query may search for students under the age of 21, while another search for students age 18, but will share fields such as Name and Age.
- 2). Go to "Queries" in the database window. Click "Create Query in Design View."
If you have an existing query that you wish to create a relationship in, open the existing query in "Design View." - 3). Choose the "Queries" tab and add the queries you wish to use. If using an existing query, skip this step.
- 4). Scroll down on both queries until you see the fields you wish to create the relationship with. This is also known as joining.
- 5). Drag the field from one query to the matching field in the other query. When a thin black line appears, the relationship has been created. Create the query as normal from this point on.
- 6). Create query relationships also by going to "Relationships" in the toolbar. Add tables and queries by clicking the "Show Table" icon. Follow Steps 4 and 5 to create the relationship.
