How to Use Parameters in Query MS Access

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

1. Go to the Create tab in MS Access.
2. Select Query Design to open the query builder.
3. Select the table you want to use 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 for the field you want to filter, enter a prompt enclosed in square brackets [].
6. Click Run to execute the parameter query.
7. Enter the parameter values when prompted, verify the results are correct, and click OK.