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.

Home on the range


Setting up criteria in a parameter query

In the Criteria field, enter "Between [Enter low amount] And [Enter high amount]."

COURSE TEXT

What if you want to retrieve all the data between two values, such as payments made between January 1 and March 31?

And what if you need to use many different values? Suppose you want sales figures for items in many different price ranges. With a parameter query, you can enter a new range of values each time you run the query, so it gets all the results you need.

In this lesson, you'll see how a parameter query returns lists of donors based on the dollar range of their contributions. This makes it easy to respond appropriately—with a coffee mug, for instance—to people who have donated between $100 and $499.

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

  Go to previous page    Next Go to next page
advertisement