multi-table query

L

Lauren B

I am attempting to do a query using fields from two tables. Table 1
contains basic customer information and Table 2 contains information if the
customer is working with a vendor (not all customers have an entry in this
table as not all customers are working with a vendor). The tables are
joined by a common Customer ID.

When I use fields from Table 1 only it works fine; however, when I bring
fields from Table 2, it only returns customers that are working with a
vendor and have an entry in Table 2. Is there a way to view customers that
are both using and not using a vendor while still including fields from
Table 2 in my query?

Thank you in advance for any assistance.

LB
 
R

Rick B

Yes, right-click the 'join' that is drawn between the two tables and change
it to...

Include ALL records from table Customers and only those records from Vendors
where...
 
G

Guest

Right click on the line that joins the 2 tables in the query and select join
properties. Select the option show all from table 1 and only those from table
2 where join fields are equal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top