I have a stumper here. I need to print two separate reports at the same time (One group is based on campers and one is based on volunteers) for a roster. I simply created two separate reports and called them rsubCampers and rsubVols and then created a third report called rptRoster and then placed both subreports on the rptRoster without Parent/Child relationship. I placed a page break between two subreports and it works just fine and dandy.
HOWEVER — Now, the requirements has changed. Now, we need two column reports to save paper and when I set it up in the rptRoster, the first “section” (Campers) doesn’t show two columns because the page break would have messed up the second column, so by default, Access ignores the two-column setup. So, I set up both subreports to show two columns each, but then it doesn’t show up in rptRoster as if subreports’ formatting get stripped out.
How in the world do I somehow open one report and tell it to print two separate reports in multicolumn and yet keep both subreports on separate pages? 
