How to Get Data Between Two Dates in MS Access

Quick summary

This tutorial shows how to filter data between two dates in MS Access using the Query Design tool and a date range criteria expression. Follow the steps below to retrieve date-filtered records from any Access database table without writing SQL manually.

Steps

1. Open the database where you want to run the query.
2. Go to the Create tab in the MS Access ribbon.
3. Click Query Design to open a new query in Design view.
4. Add the tables you want to include in the query.
5. Drag and drop the fields you want to display into the query grid.
6. Enter the date filter expression in the Criteria row of the date field.
7. Click Run to execute the query and see the filtered results.