Solved Query to Find Items a Week Overdue

Is something that is due today, overdue? :).

Anyway, whatever the OP wants!
 
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]
 
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

Back
Top Bottom