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

Change the JOIN between the two tables to an OUTER.

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

kh

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