Hi all,
I'm trying to build a report that shows every product category and then lists only a few products (not all products) within each category. I want to limit the products to no more than 3-5 for each category. I keep thinking I need to use a SELECT TOP query but the more I research it the more it seems it should only work with calculated fields so maybe I'm going about it the wrong way? I can't seem to figure out the syntax for the query to build the report.
The two fields I am using are ProductName and ProductCategory from the ProductsT table, so the report would be grouped by ProductCategory with a selection of 3-5 ProductName below it.
Thanks for your advice.