After creating a prompting query, you can edit it just like any query.
Procedure
- Open an existing prompting query.
- Click Edit. You see the Edit Prompting Query dialog box.
- In the query string, edit the existing placeholders as required, or add new ones.
You can have multiple prompts in a prompting query.
- Click Next to open the Edit Prompting Query - Customize Placeholders dialog box.
- In the Type or Attribute column, edit the value used in the query.
Edit or add a type, as required. Your query prompt shows the entries you defined for that type.
- Click Next when you have finished updating the placeholders.
- In the Save dialog box, update the description of the prompting query you modified.
- Click OK.
- To check your query, select it from the appropriate folder. Set the value from the list you created, then select a format and click Run. Click Edit to modify the query.