• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Queries > Top Values Property

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 in either direction you choose. In a column of baseball batting averages, for example, you could find the top 75 hitting artists or the 20% at the bottom who can be counted on to strike out with the bases loaded.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint