How To Create Reusable Parameter Queries In Access 2010


show more Creating reusable parameter queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating reusable parameter queries

Sometimes when you run a query, you would like run the same analysis but change the group that you're running it for. You don't have to create multiple queries. A Parameter Query will allow you to reuse one Generic Query. Let's build on the Maryland Orders Query we made in the previous lesson. Right-click on it and choose Copy. Then right-click in the white area at the bottom and choose Paste. Rename it Orders by State. Click OK.

Right-click on it and open it in Design View. In the State Criteria, erase MD and type in a square bracket, then type What State? And then close the bracket. What you're doing is entering in the question Access is going to ask you. So use real English. Click on the View button, and a dialog box will open asking you "What State?". Enter in NY for New York and click OK, and now you can see your orders for New York.

Right-click on the tab to close it, and if it asks you to Save, please do, and let's try it again. Double-click on Orders by St...

Creating reusable parameter queries
Video duration: 1m 29s 3h 30m Beginner

Viewers:

Creating reusable parameter queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...