Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Access Tip: Find Records Between Two Dates
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

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.

Find Records Between Two Dates and sum by multiple Upload Images   Link  
Petya Pashova 
6 years ago
Hi Instructor Rost,
I enjoy your tutorials very much and help me build my first database. But I'm having issues with one of my reports. can you help me please?
I created a quiry which runs for a specific date I enter. Then I created report on this query, I added totals for the values but I also need a subtotal of a set of the records. I use the Dsum function but since the report is within certain date range, I come up with an error on the Dsum. How to fix that error? Read More...
Add a Reply
Access Tip Find Records Between Two Dates Upload Images   Link  
7 years ago
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:
Add a Reply
Access Tip Find Records Between Two Dates Upload Images   Link  
Tony Barnett 
7 years ago
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. Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

1/22/2022Next Appointment
1/18/2022Access B2 Upgrade
1/17/2022Access Beginner 2 Links
1/17/2022Access Beginner 2
1/17/2022New Record on Top
1/13/2022Missing References
1/13/2022Access Beginner 1 Links
1/11/2022Access Fast Tips
1/11/2022System Defaults

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access tips between inequality inequalities between two dates  PermaLink