Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Create it once, use it often


Parameter queries can answer multiple questions

One parameter query can answer multiple questions.

COURSE TEXT

You're probably familiar with the basic Access select query. To create a select query, you choose its structure and criteria, such as sales figures for a specified month.

But what if you want to search for different months every time you run the query? Today you may want sales figures for September, but next week you might need them for April.

A parameter query enables you to enter different criteria each time you run the query. You can get just what you need, without having to recreate the whole query in the process.

To continue reading this lesson on your own, click Next.

  Go to previous page    Next Go to next page
advertisement