Missing Records in a 2 Table Query
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" u44745@uwe wrote in message news:86e7b3bbffa94@uwe...
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...
|