Expression Builder wizard - Subquery page

Use this page to create an original subquery or to create a subquery that is based on an existing query.
Create a subquery that is based on an existing query
Select this option if you want to use a query that you have already created as the basis for your new subquery.
Create an original subquery
Select this option if you want to type all the text for the new subquery.
unlabeled list
If you selected the Create a subquery that is based on an existing query option, select a query from this list. The text for the query that you select is added to the Create or edit a SELECT statement field for you to edit.
Create or edit a SELECT statement
Change the text of query that you selected. The changes that you make to the text in this field affect only the new subquery. The text of the selected query remains unchanged.
Type a SELECT statement
Type the text for the new SELECT statement. If you prefer not to type all the text for the statement, you can cancel the Expression Builder wizard, use the SQL builder to create the SELECT statement, and then reopen the wizard and select the query that you created.
Related tasks
Creating expressions in the Expression Builder wizard
Editing expressions in the Expression Builder wizard
Replacing expressions in the Expression Builder wizard
Related reference
Expression Builder wizard - Expression Types page

Feedback