Multiple Record Source?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can a report have only one Record Source? Is it possible to do calculations based on multiple queries in one report? I'm trying to summarize a comparison of two tables in which table 1 has records that table 2 doesn't have AND table 2 has records that table 1 doesn't have

Thanks
Ray
 
rayjr said:
Can a report have only one Record Source? Is it possible to do calculations based on multiple queries in one report? I'm trying to summarize a comparison of two tables in which table 1 has records that table 2 doesn't have AND table 2 has records that table 1 doesn't have.
Click to expand...

Only one record source!

If the report is such that you can get away with using two
subrepots, each subreport can have its own record source.

If the report requires the data to ne "intermingled", then
you have to do it with a single report. The trick to any
report is to create a query that presents the report with
the appropriate data. In this case you'll want to either
Join or Union the results of two other queries that select
the unmatched records.
 
Back
Top