finding like and unlike records from two tables

Posted on 2011-05-05
Medium Priority
Last Modified: 2012-05-11
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
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
Question by:davetough
  • 2
LVL 12

Accepted Solution

danishani earned 2000 total points
ID: 35699233
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.

LVL 12

Assisted Solution

danishani earned 2000 total points
ID: 35699251
See also for more info this link by Microsoft;


Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question