finding like and unlike records from two tables

Posted on 2011-05-05
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
    LVL 12

    Accepted Solution

    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

    See also for more info this link by Microsoft;


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now