I am trying to create a query that will pull data from multiple personnel tables. I have around 20 reports that list over 5000 personnel per report. These reports range from leave days to different types of pay. These personnel are all from the same group, but are not all on every report. I want to create a query that will let me pull specific information (mismatch reports) from these different reports. I have loaded the tables into Access, and I thought I had a relation ship built, but all my queries come up with no data. I also want this query to delete duplicate information. The common info for all the tables is Name, work area and Social Security Numbers. They appear the same for each individual in every table that they are listed in. An example would be to have a query that would pull leave dates and bonus from two different tables into one report listed by section they work in. Thanks.