<div>
<div class="content wysiwyg-content">
I have 2 tables, Hisory and Core Pin History, they both have a field labled ID. &nbsp;I use that filed to tie the table together for data entry on the same form. &nbsp;That field is populated in the History table and copied to the Core Pin History table but only if the use enters data in the fields that go with Core Pin History. &nbsp;If they don't enter data into Core Pin section then no data is entered into the Core Pin history table. &nbsp;So now i can create a query and link the 2 fields in the query and get records from both tables that have matching ID's but i need to know is how do i get only the records in the history table that have ID's that do not have any matching ID numbers in the Core Pin History table?
</div>
</div>


I have 2 tables, Hisory and Core Pin History, they both have a field labled ID.  I use that filed to tie the table together for data entry on the same form.  That field is populated in the History table and copied to the Core Pin History table but only if the use enters data in the fields that go with Core Pin History.  If they don't enter data into Core Pin section then no data is entered into the Core Pin history table.  So now i can create a query and link the 2 fields in the query and get records from both tables that have matching ID's but i need to know is how do i get only the records in the history table that have ID's that do not have any matching ID numbers in the Core Pin History table?

record search criteria

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.