From the course: Access 2016 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Creating flexible queries with parameter requests

Creating flexible queries with parameter requests

From the course: Access 2016 Essential Training

Start my 1-month free trial Buy for my team

Creating flexible queries with parameter requests

“

- Sometimes you'll want to create a query framwork that answers many variations on the same question. Instead of hard coding your queries to use the exact same criteria every time they're run, you can instead ask the user when it's run for the criteria then. This is called a parameter request and they're another very useful tool to have when building out your databases. Let's start by creating a very simple query here in the Designer, and I'm going to pull in data from our Guests table. Let's go ahead and close the Show Table window and I'm going to pull down the FirstName and LastName field, and also the Country just by double-clicking on each of these here. Now we've seen how we can specify a criteria that looks for a specific value. So for instance, if I come down here into Country and type in France here, and if I were to run it, we can see that there are a total of five guests that come from France. Let's go ahead and switch back into Design View. Now if we were to save this…

Contents