Finding unmatch records between two tables

[gemini2]

This question may seem simple but I'm still new to access. How can
do a query that will return only a lis
of records that do not match records in another table? I have
table name Project and anothe table name monitoring. I need t
develop a list of project records that never had monitorin
information submitted for it. I tried using the outer join but th
result gives me all the records in th
project table and only the records from the monitoring table tha
match the project table records. I want only the records from th
project table that don't have a matching monitoring record

 

[David Lloyd]

You can use your existing outer join and add a criteria to one of the
columns in your Monitoring table specifying that it is Null.

For example:

WHERE Monitoring.MyField Is Null

This will give you the Project records with no Monitoring information.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


This question may seem simple but I'm still new to access. How can I
do a query that will return only a list
of records that do not match records in another table? I have a
table name Project and anothe table name monitoring. I need to
develop a list of project records that never had monitoring
information submitted for it. I tried using the outer join but the
result gives me all the records in the
project table and only the records from the monitoring table that
match the project table records. I want only the records from the
project table that don't have a matching monitoring record.