Using Parameter Queries
Managers run some queries repeatedly, but the criterion value changes. You can design a query to alter the criteria each time you run it. This kind of query is called a parameter query .
In the Criteria cell, under each field that you plan to change with each query, enter a prompt statement enclosed in square brackets ([ . . . ]). Access will display this prompt whenever the query is run.