Query Records by Date Before Midnight in MS Access

In this Microsoft Access tutorial, we'll tackle the challenge of querying records up to 11:59:59 PM with specific criteria tailored for a meticulous request. You'll learn how to adjust query criteria, use date functions like DateAdd, and implement VBA for seamless form integration.

Dylan from Newton, Iowa (a Gold Member) asks: Using a technique similar to your "Value From a Form" video, I have two text boxes on my main menu to specify a start date/time and an end date/time for a query that shows orders within that time range. I want the default to be all orders from yesterday because we check it daily. I had it set to >=Date()-1 and <Date() for the criteria, but my stubborn boss insists that the end date/time in the query criteria should explicitly be 11:59:59 PM instead of using simpler logic like <. How can I handle this requirement?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Query Criteria
• Value From a Form
• DateAdd

Links

• Date Math
• Between Wrong
• Intro to VBA

Recommended Courses

• Access Developer Courses
• Access Expert 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, query records by date, excluding midnight, 11:59:59 PM criteria, date add function, subtracting one second, custom date format, VBA button creation, Access query setup, non-VBA alternative, TechHelp tutorial