Question

.....type of query in ms access displays its own dialogue box prompting for information which is used as input for query​

Answer 1

Use parameters to ask for input when running a query

Access for Office 365 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007

To make a query in Access desktop databases ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view to edit the criteria.

Note: This article doesn't apply to Access web apps.

Understanding the terminology

Before getting into the step-by-step below, it’s helpful to understand these terms:

Parameter   A parameter is a piece of information you supply to a query right as you run it. Parameters can be used by themselves or as part of a larger expression to form a criterion in the query. You can add parameters to any of the following types of queries:

Select

Crosstab

Append

Make-table

Update

Criteria   Criteria are the “filters” you add to a query to specify which items are returned when you run the query.

For more information about the types of queries mentioned above, see Introduction to queries.

Create a parameter query

Creating a parameter is similar to adding a normal criterion to a query:

Create a select query, and then open the query in Design view.

In the Criteria row of the field you want to apply a parameter to, enter the text that you want to display in the parameter box, enclosed in square brackets. For example, [Enter the start date:]

A simple parameter query.

Repeat step 2 for each field you want to add parameters to.

When you run the query, the prompt appears without the square brackets.

Parameter prompt with the text "Enter the start date:"

Fill in the value you’re looking for, and then click OK.

You can use multiple parameters in a criterion. For example, Between [Enter the start date:] And [Enter the end date:] will generate two prompts when you run the query.

Parameter query with two parameters.