If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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... |
#2
|
|||
|
|||
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... |
#3
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|