View Single Post
  #2  
Old July 9th, 2008, 09:24 PM posted to microsoft.public.access.queries
Michel Walsh
external usenet poster
 
Posts: 2,404
Default 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...