O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

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

Using the Top Values query property

You can use the Top Values property to tell Access that you want to see the first n rows or the first x percent of the rows. If you enter an integer value, Access displays the number of rows specified. If you enter a decimal value between 0 and 1 or an integer less than 100 followed by a percent sign (%), Access displays that percentage of rows. For example, you might want to find the top 10 products you purchase or the top 20 percent of highest paid employees. In most cases, you’ll need to specify sorting criteria—perhaps by count of products purchased descending or pay rate descending—to place the rows you want at the “top” of the recordset. You can then ask for the top 10 or top 20 percent to get the answers ...

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