Two Different Queries used in 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

 

[Michel Walsh]

You need an outer join. Make a new query, bring the two initial queries.
Make a join on the appropriate field. Right click on the join line to edit
it. Use the option 2 or the option 3 (depends on which of the two queries
you brought, which one has to keep all its rows). Use that new query for
your report.



Vanderghast, Access MVP

 

[Guest]

Thank you so much Michel. That did the trick.

You need an outer join. Make a new query, bring the two initial queries.
Make a join on the appropriate field. Right click on the join line to edit
it. Use the option 2 or the option 3 (depends on which of the two queries
you brought, which one has to keep all its rows). Use that new query for
your report.



Vanderghast, Access MVP