Database Reference
In-Depth Information
Only five orders were placed in the requested period.
Now let's have the query request the range of dates each time you run it.
12
Switch to
Design
view. In the
Criteria
row of the
OrderDate
field, replace the existing
criterion with the following, entering this criterion exactly as shown and then pressing
the
Enter
key:
Between [Enter the beginning date:] And [Enter the ending date:]
7
13
Run the query, which opens the
Enter Parameter Value
dialog box.
The first Enter Parameter Value dialog box requests the beginning date in the range.
14
In the text box, enter
1/8/12
, and click
OK
.
15
In the second
Enter Parameter Value
dialog box, enter
1/15/12
, and click
OK
.
Notice that the results datasheet lists only the nine orders placed between the
specified dates.
16
Save the query as
Orders By Date
.
CLEAN UP
Close the query. Keep the GardenCompany07 database open for use in
later exercises.
