Hello everyone

I have about 30 reports, half of which are landscape, half portrait. I want to put them into one new report (which is portrait) as a series of subreports. Is this possible? When I do it now all the landscape subreports spill over onto two pages.

Any help would be greatly appreciated!

Thanks

Michael

Forget about Access. How can you print a report that is 297mm wide on a sheet of paper that is 210mm wide? What do you expect to happen?

In Word, for example, you can tell the printer to print the first page in portrait, the second in landscape. I was wondering if you can do the same thing in Access.

I'm pretty sure that you can't do that in Access, at least up to A2003 which is what I use. But I've never had the need to do it, so I may be missing something.

When I was a nipper in short pants using Paradox, you could embed printer codes in the page footers. Nostalgia...