Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 State. It asks you What State? This time type in VA, for Virginia, and click OK. Now you've got your orders from Virginia. Parameter Queries allow you to use the same query over and over, just entering in the desired criteria every time.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64717 Viewers
80 Video lessons · 124327 Viewers
52 Video lessons · 60259 Viewers
59 Video lessons · 46095 Viewers