Saving prompting queries as regular queries

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

  1. Open an existing prompting query.
  2. Type values in the prompting fields.

    You must enter this information, or you cannot save the query as a non-prompting query.

  3. Select Save As.

    The Save As dialog box opens.

  4. Type a new title and description for the regular query.
  5. Select the folder where the query is to be saved.
  6. From the Type list, select Query (non-prompting).
  7. Click OK.
  8. 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.


Feedback