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

Top Values Property

It seems that modern societies care only about the biggest and the best. If a company can't have the best-selling brand in a market, it often doesn't want to be in it at all. The weekly box office totals from the movie industry focus only on the top ten moneymakers. On the PGA tour, scratch golfers who finish 58th on Sunday might as well have stayed in bed.

The Top Values property is well suited to the needs of our times. It finds the highest values and the lowest. Access determines the “top” records based on the sorting criteria you specify. It can be set in either absolute or percentage terms, so you can use it to find the top 1% of this or the top five of that. In fact, you can limit the records found to any number or percentage ...

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