Using Parameters in a Query
A "parameter" is a value entered at run-time. Using this approach, you can allow the user to specify the search condition when the Query (or Report) is run.
STEP 1 Add the field to the Field: line in the Query window as usual. On the Criteria: line type the prompt to appear in the parameter window. Access will assume anything in square brackets is meant to be the prompt.
STEP 2 Run the Query as usual. Access will display a prompt window asking for the parameter value to be entered. The prompt you entered between the square brackets on the Criteria: line appears above the input line...
The result of the query in this example is:
