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:
- Create a Parameter Query in Access
- Creating Custom Filters in Excel
- Using Data Validation in Excel 2007
- Understanding Date/Time Functions in Excel
- Timer Application for Leopard
- Using Conditional Formatting in Excel 2007
- Quickly Find Dates in Outlook 2007
Comments on this entry are closed.