# How to Create Parameter Reports MS Access

> To create parameter reports, go to the 'Create' tab, select 'Query Design', and add your tables. Next, drag desired fields to the query grid, enter a prompt in square brackets within the 'Criteria' row, and click 'Run'. Finally, enter the parameter values when prompted and click 'OK'.

Canonical: https://livedemo.ai/tutorials/how-to-create-parameter-reports-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a39f8ab56e05a00fe0c8e/preview?step=1

## Steps

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'.