Query base on one parameter

Parameter base query help you to find wanted data from huge data.It reduces time from build more query. It’s a powerful query method. Follow this tutorial for learn it.

Follow these steps to make a parameter base query:
1. Decide that on which parameter I mean field will be base of your query. (here our example query has made with ID filed)

2. Make a query with the design view.

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

ex [Enter your ID : ]

4. Save it with a name.

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

Query run

query result

Tags : , , , ,

Share on :

Leave a Reply

7 × = fourteen