I believe this can be done but never have. I have seen an example of a monthly report that had a Front Cover sheet then various sections inside. It may have been in Northwind or some tools that shipped with Access.
I guess you would have to put a PageBreak just before the sub-report. Then to change the orientation you would put some code in the On_Open, or On_Format, or On_Print event. Something like;-
- Me.Printer.Orientation = acPRORLandscape
-
I don't know this works but is something to try!!
S7