Two Reports -> One Output

[SgtJarrow]

Here's the situation.....

I have two reports, each contains separate data about the same client....The first report is a type of summary, using a single line per account for the client to list the total of that account. The second report is a breakout of each account's activity per client.

I created two separate reports because I needed to have a different format for each report, and each needed it's own details section to do the report work.

Now I need to output them to a single Word document. The kicker is that I need page one from report one, page one from report two, page two from report one, page two from report two, etc.....In other words, I need the summary followed by the details for each client in a single report.

Anyone know what I can do about this??? I can rework the reports if necessary, but I am not sure how to have a "separate" report for each page I need. I am pretty sure I am going to have to do all the code on the fly for this one....just didn't want to go that route since it will be a LONG code set to create and I already have the reports done now. Was just hoping to be able to output as needed. Thanks in advance. "As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[padinka]

To get you started, read up on subreports the embed your account's activity report as a subreport to your summary report. Then you are going to have to write some code to run this report over and over again for each client.
Trisha
padinka@yahoo.com

 

[padinka]

To get you started, read up on subreports then embed your account's activity report as a subreport to your summary report. Then you are going to have to write some code to run this report over and over again for each client.
Trisha
padinka@yahoo.com