On a form I have a start date text box and an end date text box that are linked to a query. Right now if the boxes are left empty nothing shows up. I want to know if they are left empty is there a way to have the query show all of the dates.
This is what I have in the criteria on my query: Between [Forms]![2012 Rates Form]![Start Date] And [Forms]![2012 Rates Form]![End Date]
The dates are part of how long a program has run. Some programs have run for multiple years so a person may not know the start date. I would like the form to have an option either by leaving the text boxes blank or with something else to have all of the dates of the program show up.