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.