• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

finding like and unlike records from two tables

Hello I have datbase w/2 tables- i have made one query-
question: is this the correct way to find like records between two tables
and:
to find unlike records - would that entail alot of queries - these two tables are produced from different sources and are supposed to have same data- but frequently there are discrepancies- am looking for ways to find them
thank you
database.mdb
0
davetough
Asked:
davetough
  • 2
2 Solutions
 
danishaniCommented:
You can check for Unmatched records using the Find Unmatched Query Wizzard.
Follow the steps through the Wizzard and you will see the results, when you are done.

HTH,
Daniel
0
 
danishaniCommented:
See also for more info this link by Microsoft;
http://support.microsoft.com/kb/319017

HTH,
Daniel
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now