Make Query base on two parameter

Two parameter base query will help you to find out data from you database depends on your two parameter.
Follow these steps to make a two parameter base query:

1. Decide that on which are parameters i mean which fields will be base of your query. (here our example query has made with ID and city fields)

2. Make a query with the design view.

3. In criteria option write down [Your message ] where you need to user input. With in third bracket you must write message what you wanna to display in front of your database user.

ex [Enter your ID : ]

[Enter your city : ]

4. Save it with a name.

Example : When you will click on your query. It will ask for two parameters. Give your parameters and get query result.

Make your Query according to this image:

Two parameter query making

Query make

run query input

First input

input in query

second input

2 parameter query result

Query result


Share on :

Leave a Reply

3 − two =