O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

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

Finding the Largest and Smallest Values in a Field by Using a Query

When you create a query, you can have Access display a set number of the highest and lowest values in the query’s results. You can also have Access display rows that contain the top or bottom values by asking Access to display a certain percentage of rows in the query’s results. For example, if you reward the top 10 percent of your sales staff, you can create a query that sorts the query results according to the values in the Total Sales field and display the best values. When you filter a query’s results by a percentage, you don’t need to know the exact number of records in your table. In other words, if your sales staff expands from 30 to 40 employees, creating a query that ...

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