Solved Query to Find Items a Week Overdue (1 Viewer)

Cronk

Registered User.
Local time
Tomorrow, 02:28
Joined
Jul 4, 2013
Messages
2,770
Is something that is due today, overdue? :).

Anyway, whatever the OP wants!
 

Bean Machine

Member
Local time
Today, 11:28
Joined
Feb 6, 2020
Messages
98
Okay, thanks. Then you could try using BETWEEN. For example:
Code:
...WHERE Date() BETWEEN [DueDate] And [DueDate]+4
Hope that helps...

Using that statement worked quite nicely, I have also allowed for the user to search items due or overdue via their own input. I have two textboxes (one called txt_StartDate and the other called txt_EndDate) with the code being something like this: >=[Forms]![Item Search]![txt_StartDate] And <=[Forms]![Item Search]![txt_EndDate]
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:28
Joined
Oct 29, 2018
Messages
21,359
Using that statement worked quite nicely, I have also allowed for the user to search items due or overdue via their own input. I have two textboxes (one called txt_StartDate and the other called txt_EndDate) with the code being something like this: >=[Forms]![Item Search]![txt_StartDate] And <=[Forms]![Item Search]![txt_EndDate]
Hi. Congratulations! Glad to hear you found a solution that works for you. Good luck with your project.
 

Users who are viewing this thread

Top Bottom