Can you design a report that pulls data in from mulitiple "Record" Sources?

[GMasterLi]

For eg. if I want to have 3 "Tables" in a single report view, with:

1) Table 1 - based on Query A
2) Table 2 - based on Query B
3) Table 3 - Based on Query C

Can i create one Report that pulls it for all three? If so, how do I do this, if the source record seems to default to the queries in question?



Thanks!

[pbaldy]

It would depend on the relationship between the tables, but it sounds like you want subreports.

[GMasterLi]

The three tables are actually independent of each other. I basically want to have 3 table "blocks" in the report. Any thoughts? thanks btw.

[pbaldy]

Besides the subreports thought?

[GMasterLi]

Thanks - sorry am Access Noob so not even sure how to work subreports. I'll figure it out. And thank you again.

[pbaldy]

No problem. You can just create a report from each of your queries, then add those 3 reports as subreports in a new report, using the wizard.