How to Use Parameters in Query MS Access

‍

‍

Using parameters in a query in Microsoft Access allows you to create dynamic queries where the user can input values at runtime. Here’s how to do it:

‍

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