View Single Post
  #1  
Old July 9th, 2008, 09:19 PM posted to microsoft.public.access.queries
Itenoeth
external usenet poster
 
Posts: 2
Default Missing Records in a 2 Table Query

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...