How to Access Combined Data in Two Queries

Utilize Access queries to transform the data in your database. Access database queries let you ask questions of the information in your database. Access queries can be designed by adding your table and query fields when the query is in design view. The query is enhanced when additional criteria is added to the query fields. Combining data from two queries can be done by creating a new query and adding the fields from the two queries.

• 1

  Open Access 2010 and select a database. Click the "File" tab and select one of the recently used databases from the File menu. The database opens.

• 2

  Click the "Create" tab and select "Design Query." The "Show Table" dialog box appears. Select the "Query" tab. Select one query and hold down the "Control" key. Select another query and click the "Add" button. Both queries are added to the new query.

• 3

  Click the "*" in the first query and drag it into the first column of the query. Click the "*" and select all of the fields from the query. Click the "*" in the second query and drag it into the second column of the query. Run the query by clicking the "Run" icon on the ribbon. View the results of the combined data from the two queries.