Create a single report based on multiple queries

  • Thread starter Thread starter Frank Timmons Jr
  • Start date Start date
F

Frank Timmons Jr

I have a report that is based on 6 different separate queries. If each query returns multiple records, how can I ensure that ALL of the data from Query #1 is printed one after the other, then, all of the data from Query #2 is printed directly following the last record from Query #1.

Right now my report looks like this:

Query 1 Title
First record
Query 2 Title
First record
Query 1 Title
Second Record
Query 2 Title
Second Record
etc...

I want it to look like this:

Query 1 Title
First Record
Second Record
etc...
Query 2 Title
First record
Second record
etc...

Is that even possible? Given the fact that I have 6 different queries that I want to include on the same report?
 
Umm... how is it that you are basing a report on 6 different queries? That
is likely to explain the order in which you are seeing the information.

What you describe you want simply sounds like 6 separate reports, appended
one after another. That is easy to accomplish: create a separate Report for
each of the 6 queries, and embed them in Subreport Controls on one main
Report.

Larry Linson
Microsoft Access MVP

I have a report that is based on 6 different separate queries. If each
query returns multiple records, how can I ensure that ALL of the data from
Query #1 is printed one after the other, then, all of the data from Query #2
is printed directly following the last record from Query #1.

Right now my report looks like this:

Query 1 Title
First record
Query 2 Title
First record
Query 1 Title
Second Record
Query 2 Title
Second Record
etc...

I want it to look like this:

Query 1 Title
First Record
Second Record
etc...
Query 2 Title
First record
Second record
etc...

Is that even possible? Given the fact that I have 6 different queries that
I want to include on the same report?
 
I created the report from the design view and used a select query to add all
6 queries to the same report exposing all fields from every query.

I think I understand what you are recommending here...create one main report
and just list all the subreports one after another, all 6 into the Detail
section.

If this is a shared database, will having such a report cause performance
problems? I am in the early phases of designing this new application for a
group of users and that was one of thier requests. I told them I wasn't
sure it could be done, and even if it could be done, it might cause
performance issues.
 
Back
Top