<div>
First make a Find Unmatched query, using the Query Wizard, to select records in tblItem that don't have a matching record in tblBuyer. &nbsp;Then make it into a make-table query and run it. &nbsp;Make a Delete query with the table created by the make-table query and tblItem, linking on the appropriate key field. &nbsp;This will delete the records that don't have a match.<br />
<br />
You have to make a table to do this, because if you just use the Find Unmatched query in the Delete query, you will get a message that it is not updatable.<br />

</div>


First make a Find Unmatched query, using the Query Wizard, to select records in tblItem that don't have a matching record in tblBuyer.  Then make it into a make-table query and run it.  Make a Delete query with the table created by the make-table query and tblItem, linking on the appropriate key field.  This will delete the records that don't have a match.

You have to make a table to do this, because if you just use the Find Unmatched query in the Delete query, you will get a message that it is not updatable.


<div>
It worked wonderful. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
I have 2 tables, tblBuyer and tblItem. &nbsp;Both have a field &quot;Buyer&quot;. &nbsp;I want to delete records from tblItem if tblItem.Buyer does not exist in tblBuyer.Buyer. &nbsp;<br />
<br />
Delete from tblItem - After that I am not sure how to limit records to be deleted.<br />
<br />
Thank you very much in advance. &nbsp;/ hb
</div>
</div>


I have 2 tables, tblBuyer and tblItem.  Both have a field "Buyer".  I want to delete records from tblItem if tblItem.Buyer does not exist in tblBuyer.Buyer.  

Delete from tblItem - After that I am not sure how to limit records to be deleted.

Thank you very much in advance.  / hb

how to delete records from tblA that do not belong to tblB

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.