Top 3 Records for Multiple Groups (District)

[JonLee]

This is my first post in the forum, so please forgive me if I dont use proper terminology. Also, I am attempting to do this in desgin view, as, for now, I can read SQL, but dont have too much experience writing it.



I have a table with the following structure.

Region....District....WH....Product....Aged Inventory $

There are thousands of records, unique by the Prod WH combination, across 5 districts. What I want is to pull the (highest) Top 3 Aged Inv$ values (Prod WH) for Each district.

Any thoughts?

Thanks,

[June7]

You will probably have to write the query statement in SQL View.

Review:
http://rickosborne.org/blog/2008/01/...grouped-query/
Not exactly PC but gets the point across.

Also, http://allenbrowne.com/subquery-01.html

[JonLee]

Thanks for the repsonse! I am getting better at reading SQL, so I will attempt to tailor this to my query. It looks to be exactly what I am looking for. If it works I post a solution.