Top 10

[kathleen422]

I have a table with the following data

Section
Item ID
Item Description
Qty
Amount


SELECT TOP 10 tbl_Stores.Section, tbl_Stores.[Item ID], tbl_Stores.[Item Description], Sum(tbl_Stores.Quantity) AS Qty, Sum(tbl_Stores.[Monetary Amount]) AS Amount
FROM tbl_Stores
WHERE (((tbl_Stores.[Accounting Date])=#9/30/2015#))
GROUP BY tbl_Stores.Section, tbl_Stores.[Item ID], tbl_Stores.[Item Description]
ORDER BY Sum(tbl_Stores.[Monetary Amount]) DESC;

I need for it to give me the top 10 for each section. Can someone tell me how to get that recordset

 

[ranman256]

make a 'report' table to hold the results.
in your top 10 query make it append the data to the report table , BUT for 1 SECTION. (use a parameter)

run it N times for each Section you have.

 

[kathleen422]

Ouch I have hundreds of sections. Thank you but surely there is another way to accomplish this. Somebody, Anybody Please help!

 

[kathleen422]

Bump, can anybody help me with this? Please!

 

[XLfriend777]

Hi kathleen422 - Just a thought. If you filter the data, first by section, then by Qty, would not the first 10 rows in each section be what you want? Hope this helps. Good luck.