To create a parameter query, open the query in Design view and click in the Criteria box for
the field in which you want to add selection criteria. The expression should include the text
you want to display as the input prompt, enclosed in square brackets where you would nor-
mally enter a constant value. For example, Figure 38.5 shows a parameter query that
prompts you to enter the minimum retail price you want to use as the selection criterion in
a select query.
38
Figure 38.5
To create a parameter
query, you write an
expression that
replaces part of the
selection criterion
with an input prompt;
the result ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.