Mulitple Query Report

[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?

 

[Allen Browne]

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.