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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top Ten Albums 10
Top ten records 3
Why is my Top Value query not working right? 1
top ten filter 2
Single Query for Top 10 of Multiple Items 1
find top ten records 2
Finding the top ten fastest persons 12
Top 50% Grouped by Month 3

Back
Top