You can create reports with multiple queries and nested subqueries. When you create a new query, you must give it a name. Names can contain only alphanumeric characters and underscores. The following list outlines some different ways in which you can use multiple queries and subqueries to display information in a report.
Get an average, total, or constant for the whole report (Creating an Initialization Query)
Add a related report to the end of the report (Creating Sequential Queries)
Get an average, total, or summary for each row of the report (Creating Subqueries that Return a Single Value), or Create a Single-Row Detail Query (Creating a Single-Row Detail Query)
Use another query as a condition (Creating Subqueries that Return Zero to Many Values)
Create a report where each row from the main query runs another query (Understanding Master/Detail Reports, Creating a Multi-Row Detail Query)
Put a query in the list of items for the main query (Creating Subqueries that Return a Single Value)
Create a query that only returns items that have rows in a related table (Creating Subqueries to Test for Existence/Non-Existence)