Mulitple Query Report

  • Thread starter Thread starter Antavas
  • Start date Start date
A

Antavas

Is it possible to pull data from multiple queries even though they all pull
from the same data table and put them all into 1 report? Or do I need to run
1 report for each query?
 
A report can have only one RecordSource, so here are some options:

a) Create a report (bound to one query), with subreports bound to the other
queries.

b) Create a UNION query that combines the different queries into one, and
feed the report from there.

c) Redesign your query to it returns all the data you need, since it all
comes from the one table.

d) Create one unbound main report, that contains the subreports that each
draw from a separate query.

e) Use multiple reports.
 
Back
Top