Sub Reports

[Lisa MTM]

Looking for good info on subreports, I have multiple queries I need to combine into one report. Any help would be appreciated.

 

[KenHigg]

Just add the tables / existing queries into the design view of your report's query and link 'em as needed.

Else - more info needed!

or - do a forum search on subreport!

kh

 

[Lisa MTM]

SORRY, I am so new at this I am not sure how to even do that much, I have been searching and will continue to search threads.

Thanks

 

[reclusivemonkey]

What are the relationships between the data you need to link? One to one? One to many? If all the data is the same you could use a Union query to 'stick' all the results together. If you have a relatively simple one to many relationship, adding a subform to the report should pick up the matching fields and allow you to specify the relationship.