Orphaned Row

  • Thread starter Thread starter Kathy
  • Start date Start date
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
 
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.
 
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.
 
Back
Top