Multiple record sources in a report

dan54

Registered User.
Local time
Today, 14:16
Joined
Feb 11, 2002
Messages
13
How can i use multiple record sources in one report i.e. use values from multiple record sources (queries) in one report.
 
Depending on how you intend to use them, you can build one large query with all the other queries in it, and then build your form off of that. If you mean to have dynamic recordsources, then I'll have to wonder first why you have different queries to do the same thing. Is it possible you can use a parameter query instead and save yourself some overhead?

More information might help,
David R
 
You may want to use a subreport for the second recordsource. The master/child links will keep the main and subreports in sync.
 
Ive used sub reports to put data from different queries into one report (each query representing a different table). Now i want to add up values in fields from the different sub reports and the main report in one expression. Is this possible?
 
The only way this can be done easily is if there is a relationship among the queries such that a meaningful JOIN query can be written for them.

Then you could build breaks on each grouping that you need and do some totals in the group footers.

If your queries are totally disjoint, I don't think you can do it without some complex VBA code.
 
Yep. Whether it will work or not is another story...
biggrin.gif
 

Users who are viewing this thread

Back
Top Bottom