I have a series of reports in microsoft access 2003. Each report is based on queries which retrieve information from the same table. All relationships are pukka and data integrity is enforced where needed/possible. Each query returns information which is not necessarily logically related to another query. I want 2 things:

1. The ability to generate a report of all my reports (rather than having reports on separate pages, I want to amalgamate the reports to a continuous report so when it comes to printing i only have to print this new report encompassing all reports.
2. The ability to view a report and then select text within a report and copy and paste this text into say microsoft word for further editing.

Help please!!??

1. Make one new report and put the other reports inside it as subreports.
2. The Access report would need to be exported to another format in order to select/copy/paste.
http://office.microsoft.com/en-us/access/HA100069221033.aspx

Use OLE to transfer the data to MS Word for the text and to Excel for the data manipulation.

Since the pukka is not logically related, what's the point?