Top Ten by Field

[Dougalsworld]

Hi Folks,

Have what I think will be a fairly simple problem but I just can't get the sql statement correct.

I have a query; qryTopTen
With the following fields;
Material
Planner
Quantity

Basically what I'm trying to do is return the top ten results (by Quantity) for each planner number

for e.g If I have 5 different planners I want to return the top ten results for each (50 lines total)

I've looked across the forum and found a couple of things that were close to what I needed but couldn't get them to work in the way I need, any ideas?

 

[pbaldy]

How about:

http://support.microsoft.com/kb/210039/en-us