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

[Cronk]

Is something that is due today, overdue? .

Anyway, whatever the OP wants!

 

[Bean Machine]

Okay, thanks. Then you could try using BETWEEN. For example:

...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]

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.