Access Top 10

[LTunnicliffe]

Is there away to grab the ten records with the highest value in a specific field? Kind of like Max, but Max10?

Thanks,

 

[Mudface]

Set up an ordinary select query using the fields you require, in the middle of the screen there is a 'Top Values' dropdown box, which should read 'All', click in it and type in 10, then run your query. In SQL, it would look similar to this-

SELECT TOP 10 tblResults.Source, tblResults.Result
FROM tblResults

 

[LTunnicliffe]

That is the world's worst defined box I have ever seen. I guess I have always knew it was there but didn't know what it did. Even when looking for it, it took a while to find it. Anyway, thanks for your answer. How do I get this to work in conjunction with my Groups? That is how do I see the Top 10 "Cats", "Dogs", "Fish" by price?

 

[Russell Hauf]

If you just want one "group" at a time, then filter your query on "Cats", and order the price ascending or descending (this would depend on if you want the lowest or highest prices, respectively) - then put the number you want in the dropdown (10 in your example).

If, however, you want to see the top X values of all your qroups at the same time, then you'll need to do something like this:

http://mrexcel.com/board2/viewtopic.php?t=48828

HTH,

Russell

 

[LTunnicliffe]

Thanks Russell that's just what I needed.