When you need to change the criterion value for a query, you either must edit the old query or create a new one. However, if the change involves simply altering a value, you might consider using a parameter query. A parameter queryprompts the user for the value of a particular query field, rather than having the value built into the query itself. For example, if you want to display the records for particular toy types, a parameter query can prompt you for the type, saving you from creating a separate query for each type.
Create a Parameter Query
- In Query Design view, click the Criteria box.
- Enter the text of the prompt surrounded by square brackets.
- Click the Run button on the Query Design toolbar.
- Enter a criteria name in response to the prompt.
- Click OK.
Did You Know?
You can rename a field. Access assigns a name to a calculated field. If you want a different name, click the field in the design grid, and then click the Properties button on the Query Design toolbar. Enter a new name in the Caption box, and then click OK.
|
