# How to Make Dynamic Queries MS Access

> To make dynamic queries in MS Access, open the query Design View, add selected tables, and add desired fields to your grid. Next, type a parameter prompt in square brackets within the criteria row, and click the Run button so users can enter the value and click OK.

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

## Steps

1. Open the query 'Design View'.
2. Add a table by clicking 'Add Selected Tables'.
3. Add a desired field to your grid.
4. In the criteria row of a field, type a parameter prompt enclosed in square brackets.
5. Run the query by clicking the 'Run' button.
6. Users will be prompted to enter the value and click 'OK'.
7. That's it! By following these steps, it allows you to generate and execute SQL queries that adapt to user inputs or changing conditions.