...
1) Prompts via ‘Criteria’ tab:
- Select the ‘Criteria’ tab.
- Press the ‘Add Criteria’ button.
- In the ‘Expression 1 Type:’ box, select Field or Expression – the default is Field.
- In the ‘Expression 1:’ box, (if Field is chosen), search for the field that the query should delimit (i.e., INSTITUTION).
- Choose the ‘*Condition Type:’. Press the selection dropdown for options.
- In the ‘Expression 2 Type:’ box, select ‘Prompt’, which is not the default.
- In the ‘Expression 2:’ box, select the ‘New Prompt’ link.
- When the ‘Prompt’ definition page opens, select the Field name or use the value which Query populates.
- Change the ‘*Heading Type:’, ‘*Type:’ or ‘*Format’ fields, as desired.
- Change the ‘*Heading Text:’ to what the prompt should read. This is what the query runner will see.
- Change the ‘*Edit Type:’ to reflect the editing for the query. ‘No Edit Table’ allows the query to run if the prompt field is blank (important for optional prompts). The other three options require a value in the prompt field for the query to run.
- In the ‘*Prompt Table:’, select a table which will validate the value in the prompt field. This is available only if the ‘*Edit Type:’ is ‘No Edit Table’ or ‘Prompt Table’.
- Select the yellow ‘OK’ button, which returns you to the ‘Criteria’ build page.
- Select the yellow ‘OK’ button, which returns you to all the query criteria.
- Select the yellow ‘Save’ button.
- Run the query to test the prompt.
2) Prompts via ‘Prompts’ tab:
...