Top 5 by a GROUPing?

[Jay]

I have a query which GROUPs by two fields called Sector and Model, along
with a calculated field which calculates an amount of depreciation (based on
two other fields 'New Price' and 'Sold Price').

However, what I'd like to do is just show the Top 5 models (as per the
highest numbers in the calculated field). But I want to show the Top 5 for
each Sector.

Just selecting Top 5 will give me just the overall Top 5 results, but
considering I have 6 sectors I would like the Top 5 for each, effectively
returning 30 records.

Can anyone advise how I can return Top 5 by a grouping?

Many thanks....Regards, Jason

 

[Ofer Cohen]

Can be done using Sub Queries, look at:
http://allenbrowne.com/subquery-01.html