How to Filter Query Results MS Access

‍

‍

You can specify filter conditions directly in the criteria row of the query design grid. Here’s how to do it:

‍

1. Open your query in 'Design View'.
2. Locate the 'Criteria' row in the query design grid and enter your filtering conditions.
3. Click the 'Run' button to run the query to view the filtered results.
4. That's it! Access will display the results after clicking the 'Run' button.