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]