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

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

Michel Walsh wrote:
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...