Find match in access

Posted on 2006-04-04
Last Modified: 2006-11-18

I have 2 tables in access that have a common ID. In access there is a query to find unmatched records in 2 tables, but i need is a query to find matching records in 2 tables.
Thank you.
Question by:Ygal_Benabou
    1 Comment
    LVL 5

    Accepted Solution

    You could do a simple query in Access using both table, in the query window, you link the tables with the common id fields and it will return the records where the id is equal.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
    This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now