Open a new query
--Add both tables to the query
--Drag from the field in table tableA to the field in TableB that determines
a match
--Double click on the Join line and select option 2(All in Table A and Match
in TableB)
--Repeat if there is more than one field that determines the records match
-- add the fields from table A that you want to see
-- Add the matching field from table b
-- set its criteria to IS NULL
Run the query.
SQL statement would look like
SELECT TableA.*
FROM TableA LEFT JOIN TableB
ON TableA.PrimaryField = TableB.PrimaryField
WHERE TableB.PrimaryField is Null
OR use the UNMATCHED query wizard.
New Query
Find Unmatched Query Wizard

Signature
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.
> Is there an easy/simple way to select all records from table A that DO NOT
> have a match in table B?
dbpeart - 30 Nov 2007 00:09 GMT
Thanks! If I had been more observant I could have figured out the
"Unmatched Query Wizard". Apologies.
> Open a new query
> --Add both tables to the query
[quoted text clipped - 21 lines]
>> Is there an easy/simple way to select all records from table A that DO
>> NOT have a match in table B?