Combination Report

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

Guest

I have three separate reports based on three separate queries. Now I have
been asked to combine them and I don't know where to start. I have one
report that is a list of action items, another showing issues, and a third
showing requests. I need some help here; where do I start? I need to end up
with a report grouped by project that lists the items specified above so
everything that is outstanding is in one place. When I try to create a query
from the three, I get undesirable results.

Any suggestions?
 
Make two of the forms subforms and link the data in Link Master/Child
properties of the subform control (not the actual form being used as a
subform).
 
Okay! Now how do I group the report so first the outstanding requests show
and then the action items and then the outstanding issues.

When I put the subforms in now I get one request followed by actions and
issues and then the other request followed again by actions and issues and
it's tough to read if there are no outstanding issues or actions for a
particular project.

Is there another detail section I can add, or should I put the subform in a
different place, or should I add a grouping criteria.

Thanks for any help you can give me!
 
Sorry, I guess my previous response was not what you needed. There is
another way. But first, a question. Are the record source objects for the 3
reports based on the same table? or on one table for each? If they are on
one table, is there a field that defines what is an issue, a action, etc?
 
No, it's fine and would work if the reports were more similar. The record
source for the 3 reports are based on one table for each. There is the main
table that houses all the information for the projects and three tables one
each for issues, requests, and action items, which all do a lookup to the
main table via the project name.

As I said, I want to have the requests all listed first by project, then the
action items, and the issues so there is a section for each project with all
the pertinant information grouped together.

Thanks for all your help.
 
Back
Top