Criteria Between Two Times - Microsoft Access Beginner 5


	Back to Access Beginner 5 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Criteria Between Two Times

Andrew Cleary

5 years ago

I want to filter out any dates and times More than 7 AM each day.

Example I want to show a date and time 1/21/2021 03:00 but I do not want to show a date that happens 1/21/2021 09:00.

as of right now I have to go in each day and replace my criteria so it says =#1/21/2021 06:59:00 AM#

I want the query to know that update the calendar day and keep the time the same.

	Alex Hedley @Reply 5 years ago
The DateValue covered in Expert 28 chops the time portion off a date and leaves you just that. So you could use that on your date input. Then its just a matter of adding the time. Since dates are stored in access as 1 you just need a portion of that so 7/24.

	Andrew Cleary OP @Reply 5 years ago
I figured out how to use a text box as the criteria in all my queries so the end user can use the date picker to customize the date and time of the filter for the reports. I will probably end up taking that class as it has a lot of info on what I am currently working on. Thanks!

	Richard Rost @Reply 5 years ago
Hour(MyDateTime)<=7

	Andrew Cleary OP @Reply 5 years ago
Thanks Richard, I'll try this when I get back to work in a couple of weeks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 5.

Next Unseen