I've been wresteling with this problem all day so I think its time to see if any 2WC IT guys have any ideas on how to solve it. A little background first. I'm creating a DB to track an Evaluation. The evaluation has the following form.

Evaluation Info (Evaluator, Date, Title, etc)

Facts

Conclusions

The info is stored in 3 main tables. Each evaluation can have several facts and conclusions. Each fact/conclusion has an evaluationnumber so it can be tied to the correct evaluation.

The problem I'm having is developing a report. I have a MainReport which contains 3 subreports(SubReportEval, SubReportFact, SubReportConclusion). I can print the main report fine however I need to be able to print multiple MainReports. I need to make a "MasterReport" with several MainReports. Basically I need to join these main reports in the MasterReport in VB. Anybody know how I can complete this? I can produce any MainReport and I can also produce MainReport in succession as long as I close the related queries and reports before making the next MainReport. I just can't figure out how to merge all the MainReports into the MasterReport.

Here is an idea I have though. Say there are x number of MainReports. I can run each MainReport and them export the MainReport to PDF. Then I could combine the MainReports using PDF. However, I need this to be completely automated. In the end all the MainReport.PDFs should be deleted if possible and only MainReport.PDF should remain.

TIA

You should be able to do a join command of the tables.

When I tried to join the tables each row has a fact and a conclusion. I need the rows to have a fact or a conclusion but not both. Also, I need to generate the report so that the Eval Info is printed first, then Facts, then Conclusions. It needs to look more or less like a word document which I have already set up with the 3 subreports and main report.