A common use of parameters is to prompt the user for a specific date range. For example, you might wish to see all orders for the past week. When you want to prompt the user for a specific date range, use the Between And operators, combined with parameter expressions in the criteria row as shown below:
Between [Enter the Beginning Date] And [Enter the Ending Date]
In the above structure, the user will receive two prompts – “Enter the Beginning Date” for the first date in the time period and “Enter the Ending Date”
for the last date in the time period.
Similar Posts:
- None Found
Comments on this entry are closed.