# How to Use Parameters in Query MS Access

> To use parameters in query MS Access, go to the Create tab and select Query Design. Add your desired table, drag fields to the query grid, and enter a bracketed prompt in the Criteria row. Finally, run the query, enter the parameter values when prompted, and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-use-parameters-in-query-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a5219ab56e05a00fff278/preview?step=1

## Steps

1. Go to the 'Create' tab.
2. Select 'Query Design'.
3. Select the table 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 for the field you want to filter, enter a prompt enclosed 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'.