Mulitple Query Report

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sums from Multiple Queries on one Report 1
Multiple Reports – Same Query – Underlying Data Changes Frequently 1
Count funtion in report-I'm too rusty! 1
Putting 2 different record sets on the same report line. 1
Multiple queries for graphs on same report? 2
Missing data in Access reports 6
Creating a report from a query 5
Report too slow 7

Top