Top 5 Customers

[horna]

I am writing a report that has customers, and the products that are sold to each customer. Is there a way to limit each customer's details to the top 5 products sold to them. I first have to figure out the top 5, then limit the print to just 5 product details.

Thank you very much for your help.

 

[randy700]

Something like...

SELECT Top 5 Product, Qty, Cost
FROM tblSales
WHERE CustomerID = 14

Randy

 

[PHV]

You said NOTHING about your actual schema, so just a guideline:
the TOP 5 predicate should be in a correlated subquery.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[horna]

Thank you very much. I will give it a try.