Missing Records in a 2 Table Query

[Itenoeth]

I have a query where I am combining two tables- "Leads" (contacts) and
"Listings" (addresses). Not every Lead has a corresponding record in the
"Listings" table. When I make the query, it only shows me the records that
have entries in both tables, but I want to see all of the "Leads" even if
they don't have a "Listing" so that I can then use the information in a
report. I have the feeling that this should be really simple to do, and I am
just missing something...

 

[Michel Walsh]

In the query designer, right click on the line representation of the join, a
menu should prompt you with three choices, select the one which is
appropriate for you, ie, to show all records from Leads (and those from
Listing having a match; if no match, NULL will be supply instead of a value
from table Listing).


Vanderghast, Access MVP

 

[Itenoeth]

Thanks so much! I knew it would be simple once I knew how to do it, but I
couldn't find how to do it anywhere. ^_^

In the query designer, right click on the line representation of the join, a
menu should prompt you with three choices, select the one which is
appropriate for you, ie, to show all records from Leads (and those from
Listing having a match; if no match, NULL will be supply instead of a value
from table Listing).

Vanderghast, Access MVP

I have a query where I am combining two tables- "Leads" (contacts) and
"Listings" (addresses). Not every Lead has a corresponding record in the

[quoted text clipped - 5 lines]

am
just missing something...