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

Cronk

Registered User.
Local time
Today, 18:36
Joined
Jul 4, 2013
Messages
2,282
Is something that is due today, overdue? :).

Anyway, whatever the OP wants!
 

Bean Machine

Member
Local time
Today, 03:36
Joined
Feb 6, 2020
Messages
53
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
Local time
Today, 00:36
Joined
Oct 29, 2018
Messages
8,713
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 (Users: 0, Guests: 1)

Top Bottom