Hi,
I'm probably making this much harder than it needs to be, but I just can't think of how to do this. Each year, a database is created with all employees on it. I need to pull all the employees from the last five years and delete any duplicates. Each table has the exact same fields. So basically, I'm trying to combine tables from 2005, 2006, 2007, 2008 and 2009. Most of the employees will stay the same from year to year, so by combining all the years together, I get many multiples. There will be a few that aren't multiples, but how do I combine all this info and week out the multiples?