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.

parameter query

Query run

parameter query result,ms access parameter query

query result

Share on :

Leave a Reply

+ one = 3