How to Make Dynamic Queries MS Access

Quick summary

A dynamic query in MS Access lets users filter data at runtime by entering values into a parameter prompt, eliminating the need to manually edit SQL each time. This tutorial walks through opening Design View, adding a table, setting a criteria parameter, and running the query to return adaptive results.

Steps

1. Open the query in Design View.
2. Add a table by clicking Add Selected Tables.
3. Add a desired field to your query grid.
4. In the criteria row of the field, type a parameter prompt enclosed in square brackets.
5. Run the query by clicking the Run button.
6. When prompted, enter the filter value and click OK.
7. The query executes and returns results that adapt to user input, generating a dynamic SQL output based on the entered condition.