Need help writing a criteria formula

[bgreenhouse]

Hi all:<br>
<br>
I am trying to create a report (or a query to base a report on) that displays all the fields in one table that aren't in another selected table. The two fields are identical, and have a one to many relationship, in that all the entries in one table must be in the other table, but not vice versa. I want to display all the entries in the first table that are not in the second table. Any hints?<br>
<br>
Ben<br>

 

[DougP]

Yes if you look carefully at your choices in creating a query you will see there is a &quot;Find Un-matched Query Wizard&quot; <p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>