Parameter query is simplest query as it is so simple and easy to use. It can be easily updated to reflect a new search term. When it is opened, access will ask you for a search term and show you query results according to the searches.
While running parameter queries search term acts as variable criteria which are query criteria that changes each time you run the query. Basically the parameter is provided by the user at run time. So, a parameter query can return different results based on the user’s input.
Basically there is not much difference between creating parameter queries and normal queries. The one and only difference is that you use square brackets [] to display the text to the user.
For example:
Will result in this prompt when the user runs the query:
In the above example, the data date given will be used to filter the results in the query to only those albums that are released after the data given. Here's the complete guide on how to create a parameter query.
Firstly you need to create a query just as you create any other query.
Click Query Design from the Create tab in the ribbon.
Make selection for the tables you would like to include in your query and click Add to add them to the query. After adding the tables, click the close option.
Insert the fields that you want to include in the query by double clicking them in the top pane.
The field will be visible in the query pane below it.
Here you get to specify the parameter that the user will supply. Everything that you type in between the square brackets will be displayed as a user prompt. The value supplied will be used as the criteria against the specified field.
Click to the Run icon on the ribbon to run the query.
Now enter the value at the prompt.
Results are returned, as per the parameter given. Trying running query again and change the parameter to see it’s affect on the results.
