When you need to specify date ranges in Access, remember the following helpful tips:

By default, a date includes the time of midnight 00:00:00.

So #1/1/2025# is equivalent to the expression #1/1/2025 00:00:00# or #1/1/2025 12:00:00 AM#.

When you use Between, it always includes both dates, but > or < does not include the date. So if you want to get a single month and the table data includes times, it’s best to do something like:

Field1 >= #1/1/2025# And Field1 < #2/1/2025 00:00:00#

This will ensure that you are getting all Field1 values that are in the month of January 2025.

Using Between, you might do something like:

Field1 Between #1/1/2025# and #1/31/2025 23:59:59# but you could lose records with fractions of seconds between 59 and 00 of the final date. So it’s safer using the >= And < approach.

Just a quick tip today for date ranges! Hope you are doing great!