PLEASE HELP!!! Combining 4 reports into one!!!

[TheNovice]

Good Morning all,

I need your help BAD, I have 4 reports that all run of of different queries,
the problem is that I need to get them to come out as one. We have a product
recall that requires that a customer get all of these reports, and to
seperate one at a time is defeating the purpose.

Is there a way to have them all come out back to back? or am I realy that
dense?

 

[Golfinray]

If you want them all on one page you could make one the mainform and the
other 3 subforms and link them. Choose on form to be the mainform, go to
subform and use the wizard. The subform wizard should connect them for you.
To verify, go to the properties of each subform, click the data tabs, and
check master and child link properties. If your tables are properly related
this should be no problem.

 

[TheNovice]

You mention forms, are you talking about Reports? is there a difference?

 

[Jeff@Tufts]

You could create a new report using all the different queries. When you are
using the report wizard go to one query (from the drop down menu) select the
info you want, go to the next query select the info... etc. etc.

This may be more time consuming, but it would work.

 

[Golfinray]

You can do this in forms or reports. Reports would probably be easier.