A parameter report is based on a query that prompts users for input. Here’s how to do it:
- Go to the 'Create' tab.
- Select 'Query Design'.
- Select the table(s) you want to use in the query and click 'Add Selected Tables'.
- Drag the fields you want to display in the report to the query grid.
- In the 'Criteria' row of a field, type a prompt in square brackets.
- Click 'Run' to run the query.
- You’ll be prompted to enter the parameter values. Verify the results are correct. Click 'OK'.