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