BINGO on the LEFT JOIN!

[mud2]

The fields being "compared' MUST have the same name!! I haven't tried using an alias for one of them.
I like the "NOT IN" clause ...it"s Much more intuitive aand straight forward then the "IS NULL"!
Thanks all!

[geekgirlau]

Often a good way to get a handle on the SQL statements to start with is to use the Access query builder and the graphical interface this provides to create the query, then look at the SQL view for that query. This will give you the syntax for any DAO code.

As has already been pointed out, the syntax for ADO is different - SQL Server is then your best source for testing the SQL statement.