how do you get access quesry to show you the 2 top values?

Question

How do you get access quesry to show you only the top 2 selling products?? I used the total button it only allows you to see the top 5, 25, etc... But what I want is to make it show only the TWO top selling p[roducts (most units sold).. How do I do that ?

Answer 1

Instead of using the drop-down arrow for the top value box (which only says 5, 25, etc), you need to click INSIDE the box and actually type a 2, press Enter, and then run your query. Make sure the field you getting top values from is sorted.

Answer 2

How about setting the display so that it only shows 2 items (the others will be below, accessed with scroll)?