# How to Get Data Between Two Dates in MS Access

> To filter data by dates in MS Access, open your database, go to the Create tab, and click Query Design. Add your tables, drag and drop the desired fields to display, enter the date filter into the Criteria row, and click Run to view the results.

Canonical: https://livedemo.ai/tutorials/how-to-get-data-between-two-dates-in-ms-access/
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3edeab56e05a00fe6b3a/preview?step=1

## Steps

1. Open the database where you want to run the query.
2. Go to the 'Create' tab.
3. Click 'Query Design'.
4. Add the tables in the query.
5. Drag and drop the fields you want to display.
6. Enter the date filter in the 'Criteria' row.
7. Click 'Run' to see the results.