Hello,
I am having troubles sorting data on a subreport. Basically I'm creating purchase orders (think of a multiple manufacturer distributorship) linked by customer ID. My report has information linked by customer ID and distributors, subreport has products from different distributors.
When I run the report the distributors show on each individual page like I want but the products from all the distributors show on all the report pages.
What I want is a purchase order report to show the distributor and their products only and if other products from another distributorship are ordered for them to show on separate report pages all linked by customer ID.
Im not an access pro FYI. Can anyone help please?