Mulitiple Query Report?

[BurtonBach]

Forgive me if this is a dumb question. I am relatively new to this forum and I don't seem to be able to search to this answer. Is is possible to have a report pull from two different (or multiple) queries? If this is not possible under normal report setups is it possible with VB?

Thanks in advance for any help!

 

[boblarson]

You can if you use Subreports. In fact you can put two totally unrelated reports onto a report "skeleton" as-it-were if you wish. If the reports are related then you can link them via the Master / Child links for the subreport container (container which houses the subreport on the report).

 

[anchorp]

Two followup questions if I may:

I attempted to insert the second query into the Record Source query builder and it messes up the query I had before. Is there a way around this?

Second:

I went ahead and made a subquery even though I hate all the clutter. Is there a way to remove all the formatting so only the field of data shows up from the subreport? I want it to look like just another box of data on the original report and it wants to put the same etc. all around it.

Thanks again,

 

[boblarson]

Two followup questions if I may:

I attempted to insert the second query into the Record Source query builder and it messes up the query I had before. Is there a way around this?

Subreport

Second:

I went ahead and made a subquery even though I hate all the clutter. Is there a way to remove all the formatting so only the field of data shows up from the subreport? I want it to look like just another box of data on the original report and it wants to put the same etc. all around it.

Sure, remove everything from the subreport's headers/footers and anything but the text box(s) for the data in the details section and then insert that into the report as the subreport. Make sure to go turn off the subreport's page/report headers and footers before using it in the main report. Also, when you put the subreport on the main report size it so it is just a minimum size.

See if that helps.