Refining Queries  «Prev  Next»

Creating a parameter query

For further practice, try this on your own in Access, using another instance. Although it cannot be graded, you can post what you have learned in the discussion area. Let's review the correct steps to take:
  1. Here is a query that displays all the company names and the states they are located in. Add a parameter that will ask the user to enter a specific state, and return the results. In the first criteria row for State, type [Enter State:], then click the View button on the toolbar to execute the query.
  2. Here is the parameter box you created. Type in TX, then click the OK button.
  3. There you go. The companies that are located in Texas are now displayed.