Top Ten Records Displayed by a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

I am trying to create a report that is based on a query. How do I Only
display the top ten items by highest volume?

Any help would be apprceiated.
 
I am creating a report based on a query. How do only display the top ten
records by the highest volume
 
You can set this in the actual query itself.
Open the properties window in the query design view and then you should see
"Top Values" in the properties. Simply type in the number 10 in that property
and you should be good to go. This can be a little unpredictable at times but
it generally behaves as expected.

Hope this helps.
 
Back
Top