ms access reports 2003

You certainly could write code to print the reports.

Access reports can have subreports that are linked on a field

mlmcc

Try a main report with Activity as header section.
Within that insert the other reports as sub reports linked ( as mlmcc commented) to the Activity field in the header.

You can surely run the reports in this order...

Put Access cannot really "Package" the reports...

In older versions of Access you could create a "snapshot" report, but this required every user to have the snapshot viewer installed.

Now in Access 2007 and newer  you can create a PDF of the report...
In Access 2007 you have to install the PDF add in, http://www.microsoft.com/download/en/details.aspx?id=9943
This functionality is built into Access 2010

So is your question here how to run this sequence of reports, ...or how to "Package them, ...or Both?

I am trying to find a way to print a set of reports as a package as in Crystal Reports.
It would be to print report 1, report 2, report 3 .... for a single activitiy that links
all the reports.  Then it would repeat for actiivty 2 and activitiy 3 ...  This should
reasult in a single report object instead of number of reports x number of activities.
The user is now printing each of the reports seperately for each activity and manually
merging the reports.

I tried to use ms access sub reports to create this package and it did nto work.
One thought was to take the design out of all the reports and putting all into one
single report but believe having all the report logic into one report may be
too  difficult.

thanks

"Put Access cannot really "Package" the reports..."
Should be:
"But Access cannot really "Package" the reports..."

Using the above suggestions ( subreports ) and more research,
was able to work on a solution.  The report is not completed because there
are 5 complex subreports but looks good so far.   thanks

ok