When creating a query, a specific date or date range can be selected for a number of fields. We can create the query to prompt for the date each time it is run, instead.
1. Open the query. 2. On the Criteria tab, highlight the specific parameter that includes the date range. 3. Change the operator from 'equals' to <ask> . 4. When the Results tab is selected or clicking 'Run', you will be prompted for the date.