# How to Create Dynamic Reports MS Access

> To create dynamic reports MS Access, open your database, click the 'Create' tab, and select 'Query Design'. Add your table and desired field to the grid. Include a parameter prompt in the 'Criteria' row, run the query, enter your parameter value, and click 'OK' to view results.

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

## Steps

1. Open your Access database.
2. Click the 'Create' tab.
3. Go to the 'Queries' section and select 'Query Design'.
4. Add the necessary table by dragging the table to your query.
5. Add your desired field to your grid.
6. In the 'Criteria' row, add a prompt for the user to enter a parameter.
7. Click the 'Run' option to see the results.
8. Enter the parameter value and click 'OK' to proceed.
