How to Get Data Between Two Dates in MS Access
- George Apostolov
How to Get Data Between Two Dates in MS Access: step-by-step guide
Open the database where you want to run the query.
Go to the 'Create' tab.
Click 'Query Design'.
Add the tables in the query.
Drag and drop the fields you want to display.
Enter the date filter in the 'Criteria' row.
Click 'Run' to see the results.
Quick answer: 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.
About this tutorial
Extract specific records between two dates by building a query in the app with the criteria row and running the results. This guide shows how to get Data Between Two Dates in MS Access in 7 steps, starting with "Open the database where you want to run the query" and finishing with "Click 'Run' to see the results". The interactive demo above is a click-through copy of the real product interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to get Data Between Two Dates in MS Access?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your data or settings. Once you know the flow, repeat it in your own workspace.
Create your first interactive demo in minutes
No credit card required • Start building today
