O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Parameter Queries

The word parameter is now often used as a cliché in bloated, pompous corporate speech, so you might come to parameter queries with an attitude of skepticism. Be assured that, despite its name, the parameter query is a model of elegant design—and extremely useful, to boot.

As you saw in Chapter 8, “Queries,” in the usual select query, you enter criteria on the design grid to restrict the records retrieved to those that meet certain conditions. For example, suppose you want to retrieve customer orders from a specific country. You include the ShipCountry (or similarly named) field in your query and enter the country—say, Canada—in the Criteria row of that column.

However, suppose you want to use the same query again and again, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required