<div>
SELECT a.*<br />
FROM a LEFT JOIN b ON<br />
b.primarykey = a.primarykey<br />
WHERE a.primarykey is not null and b.primarykey is null<br />
<br />
Will give you all records in a that don't have a match in b.<br />
<br />
Kelvin
</div>


SELECT a.*
FROM a LEFT JOIN b ON
b.primarykey = a.primarykey
WHERE a.primarykey is not null and b.primarykey is null

Will give you all records in a that don't have a match in b.

Kelvin

<div>
Thanks, Kevin. &nbsp;I'll give it a whirl.
</div>


<div>
One of the query wizard options is a &quot;Find Unmatched&quot; query, which will walk you through the steps of identifying which field(s) you want to match on, and will allow you to select other fields from the table as well.
</div>


One of the query wizard options is a "Find Unmatched" query, which will walk you through the steps of identifying which field(s) you want to match on, and will allow you to select other fields from the table as well.

<div>
Thanks again, Rey. &nbsp;That's what I have in mind. &nbsp;I'll let you know. :-)
</div>


Thanks again, Rey.  That's what I have in mind.  I'll let you know. :-)

<div>
<div class="content wysiwyg-content">
I need to find records that do not match by multiple fields. &nbsp;What's a good strategy, or is there some generic SQL statements that might give me a clue?
</div>
</div>


I need to find records that do not match by multiple fields.  What's a good strategy, or is there some generic SQL statements that might give me a clue?

In Access 2010 How can I find records in one table that have no exact match in another table?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.