When I use Between [StartDate] and [EndDate], the query only runs when the dates are different. Sometimes I will run a query for a range (09/13/2018-09/15/2018) and sometimes it could be a single date (9/15/2018). Short of having a separate query with just one Date input for the times when I do not want a range, how can I make a selection criteria that will work with both a range and a single date?
Thanks,
Jerold