No replies to this topic

[MikeN]

Hello!

I'm no stranger to R&R, but I can't figure out how to do this one! What I'm trying to do is create an export report (to CSV) that steps through the STOCK table and for every stock item give me the top 5 products that were bought along with it.

The CSV format definitely complicates the report because the first item and the five associated items have to be on the same line... which makes grouping the products complicated.

Is this even do-able? Any help with the logic/layout of the report will be greatly appreciated, TIA!

Mike N