Return all fields even if lookup is empty

[skarden]

I have 2 basic tables. 1 is Customers and the other is States. I am using the States table as a lookup for the StateID field in the Customers table.

Since I want to merge this into Word, and have the State name appear, I built a query with the 2 tables linking the Customers.StateID to the States.StateID. However, since I don't have the State for everyone in my Customers table yet, when I run the Query I only get the Customers that have a StateID assigned to them.

How can I get all Customers and those that have a StateID, it will return the name of the State from the States table?

Thanks,



Stuart

[nicknameoscar]

My apologies if I have misunderstood your question.

In the query design view try double clicking on the line that links the tables. (Sorry, I have been using Access for over 3 years but I still can't remember the 'official' names or designations for many Access 'things')

After you double click on that line experiment with options 2 and 3 in the bottom portion of the message box that appears and see if that gets you the results you want.

[skarden]

Thanks! I did this and picked option 3, Include all records from Customers and only those recrords from States where the joined fields are equal. Then I included the StateName field from the States table in the query (and *not* the StateID field from the Customers table). Works perfectly!!

Thanks again,

Stuart