How to Create Parameter Reports MS Access

Quick summary

This tutorial shows how to create a parameter report in Microsoft Access by building a Query Design with custom criteria prompts. Using square bracket parameters in the criteria row lets Access prompt users for input each time the query runs, filtering results dynamically.

Steps

1. Go to the Create tab in Microsoft Access.
2. Select Query Design to open a new query in design view.
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 down to the query grid.
5. In the Criteria row of a field, type a prompt in square brackets to define the parameter.
6. Click Run to execute the query.
7. When prompted, enter the parameter values, verify the results are correct, and click OK.