How to Create Parameter Reports MS Access

‍

‍

A parameter report is based on a query that prompts users for input. Here’s how to do it:

‍

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Select the table(s) you want to use in the query and click 'Add Selected Tables'.
4. Drag the fields you want to display in the report to the query grid.
5. In the 'Criteria' row of a field, type a prompt in square brackets.
6. Click 'Run' to run the query.
7. You’ll be prompted to enter the parameter values. Verify the results are correct. Click 'OK'.