3. Enter the parameter parameter query before running the query to display one or more predefined dialog boxes that prompt for parameter values (criteria). In the Criteria cell under each field that you want to use as a parameter, type the appropriate prompt in square brackets. Microsoft Access Displays the prompt when this query runs.
In this design view, you add a guideline to the Date field: [Enter the date to query:]
When the query runs, a dialog box pops up,
Requires that the parameter value be entered, and that the message is the text within [] of the guideline.
If you press the Cancel key, the query terminates, and the query results are not present.
The run result of the query, because the input parameter is "99-7-15",
So only the record of the shipping date of July 15, 1999 is listed. You can also enter more complex expressions in the guidelines, such as for fields that display dates, fill in the criteria with Between [type start date] and [type End date], and the runtime will have two consecutive dialog boxes that require you to enter a start date and an end date, respectively. The result displays a record between these two dates.
