Understanding parameter queries

So far we've seen lots of ways that you as the query designer can control the…records that are displayed in the query results.…But what if we wanted to set up a framework and allow the end user of our query to…supply some of the input?…Lets go ahead and take look at this qry_EmployeesAZ, and I am going to…right-click and go into Design View.…And you can see that this query has a criteria of Arizona, or AZ.…If I run this query, it's going to return all the employees that live in…the state of Arizona.…Now the results might change over time as we gain or lose employees within…our organization, but the underlying structure of the query is always going to be the same.…

It's always going to return the employees that all live in Arizona.…Let's take a look at the Design View again and we'll see how we can make this a…little bit more flexible.…So back in the Design View, I am going to get rid of the criteria AZ.…We can use what's called a parameter query in order to prompt the end user for a…little bit of extra information when the query is run.…