How to Use Parameters in Query MS Access



Guide

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

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline