Quick summary
A parameter query in MS Access lets users filter data dynamically by entering values at runtime, without modifying the underlying query design. This tutorial walks through every step of creating a Query Design with criteria prompts using square-bracket syntax so results update on demand.
Steps
- Go to the Create tab in MS Access.
- Select Query Design to open the query builder.
- Select the table you want to use and click Add Selected Tables.
- Drag the fields you want to display in the report to the query grid.
- In the Criteria row for the field you want to filter, enter a prompt enclosed in square brackets [].
- Click Run to execute the parameter query.
- Enter the parameter values when prompted, verify the results are correct, and click OK.
