Select a Weekly Date Range In Access 2007 Based On The Current Day
I have a Customer Order Table with ShipDates. My Operations Mgr wants to be able to click a button and see what is supposed to ship this week. (Monday Through Friday)
See attached table as an example of what I have. I have put it on a excel spreadsheet for convenience.
Is there an Access 2007 Select statement or formula that I could use based on the Current Day to select out the "Current" Monday through Fridays orders? I would like to be able to do this regardless of what Month it is. Is this possible?