Orphaned Row

K

Kathy

Hello,
I have two tables that are linked through a form for data
entry. The problem is that one of the tables has 1088
records and the other 1087...there has been some
converting of data from excel and I am just wondering if
one of the rows is orphaned? Is there a query (or
something) that I can run on the two tables to find what
record is orphaned?
Thanks so much...the support site has been really helpful.
Kathy
 
R

Rolls

Are these random tables, or do they both have a common field?

Join the common field with a left join, then a right join. (Either a 2 or
3). Under criteria insert "Is Null" on one side or the other. This will
tell you which records are on one side and not the other.
 
V

Van T. Dinh

If you have a matching pair of Fields, then you can use the Unmatched Query
Wizard available in the Queries tab of the Database Containers window.
 
Top