Hi All,

I have a problem doing an outer join between two tables.  They are regular
access tables.  I have read through all the questions and answers for the
topic and tried various things but still it will not work.

Table 1 has 205 records.  I want to join with table 2 on an ID field.  I have
3 criteria on table 2.  I included the null clauses in various syntax's to no
avail.

Here is the query:

SELECT a.*, b.Rate
FROM [Provider Trend Rate Final] AS b RIGHT JOIN [Trend Projections - Step 1]
AS a ON b.Provider_ID = a.[Prov ID]
WHERE (((b.Product_Line)='COM') AND ((b.Type)='B') AND ((b.IP_OP)='IP')) OR (
((b.Product_Line) Is Null) AND ((b.Type) Is Null) AND ((b.IP_OP) Is Null));

This gets me 154 rows which is not correct.  I want 205 rows.

Can anyone help?

Thanks!