Web Development



Query today between time

New to access. I have created a basic query that shows associate's orders completed the from the previous day using " Between Now() And Now()-1" pretty basic. My boss would like to show orders completed between now and the beginning of shift (6:00 AM or 6:00 PM). I'm thinking I need to use the where function but all attempts have been futile up to this point. Any guidance would be appreciated.

Getting closer with this:
Between Now() And (Now()-1+Hour(([Completed Orders test].[Completed Date])>6)+Hour(([Completed Orders test].[Completed Date])<18))

But still not right. Thanks for any help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums