Microsoft Office Tutorials and References
In Depth Information
Creating Flexible Parameter Queries
when you click OK in the Enter Parameter Value dialog box, the query opens
in Datasheet view, using the parameter value you specified. In this example,
the query shows only records that have 9 as the month number in the
Order Date field, as shown in the bottom half of Figure 2-15.
Figure 2-14:
Defining
and using
a query
parameter.
Book III
Chapter 2
Figure 2-15:
The result
of opening
a parameter
query and
specifying
9 as the
month
number.
You also see the Enter Parameter Value dialog box if you enter a typo or
another error and Access doesn’t recognize a field name in your query
design.
Search JabSto ::




Custom Search