Creating One Report from Multiple Reports

[DanAuber]

I have a Form which prompts for information - this information is then used to produce Ten Reports.<br>What I want to do is end up with one (Word ?) Document that is all Ten reports combined - just with each on different pages.<br>Does anyone know a way of linking up reports in this way ???<br><br>Any help gratefully received <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[DougP]

If you do a mail merge to Word instead then you can have one Word doc that is 10 pages.<br><br>Here is an example, say you are mailing a letter to 10 people and it reads:<br>-----------------------------<br>Dear &lt;Salutation&gt; &lt;Firstname&gt;<br><br>You are Overdue &lt;Overdueamount&gt; for the month of &lt;Month&gt;<br>------------------------------------------<br>Ok so every where there is a field on your Word doc it will fill in the appropriate info from Access.<br>And since you have 10 people in your database that are over due you will get 10 pages which are exactly the same but the names and over due amount and months will be different.<br>These fields are whats in your access database.<br><br>Does that make sense and can you adapt it to your situation.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[DanAuber]

DougP<br><br>Thanks for the suggestion - but I don't think it helps. - I have ten completely different reports being produced from criteria entered in a form - a server name (Report examples from this:-the first report shows details of a particular server, the second report shows control cards on the server, the third shows disk groups and volumes on the server etc) - it would be impossible to combine all the reports as one query/report - it is simply too complex.<br>I then want to create 1 word document that is all these reports appended together, and I want to automate this process. Does that make it clearer ???<br><br>dan <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[meee]

ever hear of subreports??????

 

[DanAuber]

No I never heard of sub-reports - perhaps you could enlighten me a little <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>

 

[DougP]

a Subreport is a report that is added to a main report<br>Do you know what a subform is? It's very similar<br><br>Here is an example<br>Say you have an Invoice, OK<br><br>at the top is the Invoice number, Date and customer information (for a simple one)<br>OK below that you have what he orderd<br>from one to many parts or itmes<br>so the bottom of the report would be a subreport.<br>When you print the Invoice it appears as one document.<br>the sub report is looking at different data which can be keyed to the main report or not. In our example it is keyed to the Invoice number.) This is a Child/Master Link.<br>Now you can have many subrepsorts (there is some dis-agreement as to how many and it depends on your version of Access '95 '97 or 2 Grand.<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[DanAuber]

Cheers - sounds perfect<br><br>Dan<br><br>I don't suppose you also know the VB to move the Master report to a word document ? <p>Dan Auber<br><a href=mailtoanAuber@aol.com>DanAuber@aol.com</a><br><a href=

http://members.aol.com/_ht_a/danauber/myhomepage/>Dan

Auber's Home Page</a><br>