Simple SELECT question

[Steven811]

Hi

To display a Rep field from a linked customer table, I have used a SELECT query for the 2 linked tables. This (correctly) shows the customers where they have a rep but I wish to see the customers that don't have a rep allocated to their account also.

How do I modify the relationship or query to do this.

Steven811

 

[Mile-O]

Change the JOIN between the two tables to an OUTER.

 

[KenHigg]

I'm not sure I fully understand the question, but have you tried putting IsNull as a criteria in the rep fld?

kh

 

[MStef]

Hello Steven811!
In the query, right click on the relationship
between two tables. Click on "Join Properties",
chose 2. (MStef alias Štef)