Access Tip: Find Records Between Two Dates

News User Comments History Notify Me

7/23/2012 5:57:05 PM
Access Tip: Find Records Between Two Dates
By Richard Rost

In this free tip video, I'll show you how to find records between two dates using an Access query. We'll use the BETWEEN keyword and an inequality. For more on this subject, see my Access 2010 Beginner Level 5 class.

Permanent Link
Keywords: access tips between inequality inequalities between two dates

Post Reply

Access Tip Find Records Between Two Dates Comment from Stefanie @ 10/27/2015

Dear Rick,
I created a query to return data between two dates. However, the report created from this query is asking for the start Date twice. Do you know why this is happening?

Reply from Alex Hedley:

Does the Query when you open that?

Show Just This Thread Post Reply

Access Tip Find Records Between Two Dates Comment from Tony Barnett @ 4/3/2015

Those nine fields are dates of expiration for various job requirements. What I want is when I type in a beginning and ending date I want the name of the employee, plus any and all items that appear between those two dates.

Reply from Alex Hedley:

Add the BETWEEN criteria in each Field
OR is down so stagger then one on each line.

Show Just This Thread Post Reply

Access Tip Find Records Between Two Dates Comment from Tony Barnett @ 4/2/2015

to my previous question I have access 2010 and excel 2010. All records are already entered in excel.

Show Just This Thread Post Reply

Access Tip Find Records Between Two Dates Comment from Tony Barnett @ 4/2/2015

I need to look for records between to dates that I enter. Each record has 9 different dates to look through. When access finds a match, I what to print the name on the record and what was a match.

Reply from Alex Hedley:

What is it you're storing information about?
Is there a reason my the Table has 9 different Date Fields and not 1 that you then add as many records as you need.
The other option is having your Criteria in each Field
AND - Across
OR - Down

Show Just This Thread Post Reply

Access Tip Find Records Between Two Dates Comment from Alvir @ 4/18/2014

Sir, how do i set the formula which is required on my data. In excel, im doing this; =if(returned date=0, today()-submission date-16, returned date-submission date-16) how to do this in ACCESS?

Show Just This Thread Post Reply

Add Your Comments or Subscribe

If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Required
Your Email:	NOT Public
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 5+1:

	Notify me when the News is updated.
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever. NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard