Newbie trying to Return Top 5 for Each in a Group

[deluga.69]

And I really mean Newbie. I know nothing about programming. I've searched online for a solution, but I can't seem to translate any of the examples I've found into something that would work for me.

I need to return the top 5 releases for each distributor. I'm trying to get this from a query - qry_MS_Detail_All_Titles - with the following fields:

distributor_display_name, picture_name, release_amount, distributor_id, and release_id

I'm sure I've seen the solution, but being so new to this it could smack me upside the head and I wouldn't know it.



I don't really understand the syntax rules properly, so I think that may be my biggest challenge. I am hoping to see the result with my names; perhaps that will help it click for me.

Any suggestions would be helpful
Thanks,
Deluga

[June7]

Have you seen this resource http://allenbrowne.com/subquery-01.html#TopN

As Allen emphasizes, must include a unique ID field (primary key).