Using Two Different queries in a Report??

[Guest]

I am trying to create a report that has data from two different queries that
is associated by a primary key (both queries have the primary key information
in them). What I am trying to accomplish is that I have the main report
(approx 102 records) but want to associate data from another query to be
displayed on the same page as the primary data if there is an association to
that particular primary key. When I tried to combine these queries into one,
I only get the data that corresponds to the primary data, in which it is
removing all of the other primary data that has no association. Am I missing
something or is there a way to associate that data from the 2nd query without
losing the primary data?

Thanks

 

[Marshall Barton]

I am trying to create a report that has data from two different queries that
is associated by a primary key (both queries have the primary key information
in them). What I am trying to accomplish is that I have the main report
(approx 102 records) but want to associate data from another query to be
displayed on the same page as the primary data if there is an association to
that particular primary key. When I tried to combine these queries into one,
I only get the data that corresponds to the primary data, in which it is
removing all of the other primary data that has no association. Am I missing
something or is there a way to associate that data from the 2nd query without
losing the primary data?

Use an outer join instead of an inner join. Just right
click on the connecting line between the two tables and
select the option that include all records fron your primary
table and any matching records from the other table.