A
Allen_N
I have created a report that shows a list of part numbers in the Report
Header, and a list of kits containing these parts in the Detail. The list of
parts is usually less than 10, which is not problem. However, I have struck
examples in which it is > 50, causing the header to take up more than 1 page.
I tried creating a multiple-column report and dragging it into the main
report's header (i.e. using it as a subreport). Unfortunately, Access was not
fooled; the subreport reverts to single-column when embedded in the header.
Can anyone suggest a way to achieve this goal? (I suppose I could
programmatically break the parts list into several tables and put them
side-by-side in the report header, but that seems a bit BFI to me.)
Header, and a list of kits containing these parts in the Detail. The list of
parts is usually less than 10, which is not problem. However, I have struck
examples in which it is > 50, causing the header to take up more than 1 page.
I tried creating a multiple-column report and dragging it into the main
report's header (i.e. using it as a subreport). Unfortunately, Access was not
fooled; the subreport reverts to single-column when embedded in the header.
Can anyone suggest a way to achieve this goal? (I suppose I could
programmatically break the parts list into several tables and put them
side-by-side in the report header, but that seems a bit BFI to me.)