Quick summary
This tutorial shows how to filter query results in Microsoft Access using the query Design View and the Criteria row. Follow the steps below to narrow down your Access query output without writing SQL manually.
Steps
- Open your query in Design View.
- Locate the Criteria row in the query design grid and enter your filtering conditions.
- Click the Run button to execute the query and view the filtered results.
- Access will display the filtered query results after clicking the Run button.
