Article ID: 290178 - View products that this article applies to.
This article was previously published under Q290178
This article applies only to a Microsoft Access database (.mdb or .accdb).
Moderate: Requires basic macro, coding, and interoperability skills.
For a Microsoft Access 2000 version of this article, see 209250
For a Microsoft Access 97 version of this article, see 103252
In Microsoft Access, you can use variable parameters in queries. This article discusses how to construct a query that requires more than one prompt. You can use each parameter both as criteria and as a field to allow complicated evaluation of the value that is entered in each parameter.
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
The following parameter query is based on the Orders table in the sample database Northwind.mdb. It selects orders written between two dates provided by the user.
If the user does not enter either the Start Date or the End Date, the query returns all dates greater than or equal to the Start Date, or less than or equal to the End Date. If the user enters neither a Start Date nor an End Date, the query returns all orders.