I am trying to do a Microsoft Access 2013 query to return 7 days or results given just the first day. So the user will put in the date for Sunday and the query will return results for Sunday to Saturday.
I know I can have them do start date and end date but that seems excessive when they will always be looking for results for a specific range given the first date of the range.
If there is a way to even just query by a week somehow like "i want the 48th week of 2015" then that will work.
Any help is appreciated.