You can save an existing prompting query as a regular query.
This action saves a version of the query after substituting all the
placeholders with the currently selected values.
Procedure
- Open an existing prompting query.
- Type values in the prompting fields.
You
must enter this information, or you cannot save the query as a non-prompting
query.
- Select Save As.
The Save
As dialog box opens.
- Type a new title and description for the regular query.
- Select the folder where the query is to be saved.
- From the Type list, select Query
(non-prompting).
- Click OK.
- Verify the new query by selecting and running it.
When
you show the query, you see the values that replaced the placeholders
used in the prompting version of the query.