I have a table Tickets that contains a Date field. The data in these fields are in Date format as well (4/26/2010).
I'm trying to run a report on the Tickets table, but I want to filter by dates. I figured out how to filter today's date, but how would I filter Weekly, Monthly, and Yearly?
I would like my weekly filter to use the previous full Monday-Friday week. Monthly and Yearly are obvious as far as what I'm looking for.
Extra - Also, for yearly, is there any way to set up a combo box that will display the current year as well as the years that previous data contain. Example: if today were 2014 and the first record of the database was entered in 2010, I would want the combo box to show 2010, 2011, 2012, 2013, and 2014 as selections.
Thanks for your help!