I am stuck. I have 8 databases of data - one db of employee data and 7 db's of payroll data spanning 3 1/2 years. Due to the size of the data sets I had to split the data into 6 month batches to stay within the 2GB limit of Access. The seven payroll databases have exactly the same structure of 5 tables - Deductions, Earnings, Special Earnings, Other Earnings, and Taxes. I need to be able to query this collection to summarize payroll for an individual employee upon demand for legal research. Ex - I will get a call saying they need the historical payroll register for employee #123456 (or a group of employee numbers) and I need to be able to extract it. I have linked all of the 35 tables of payroll data to the Employee table using the Employee ID as the common thread. I think I need to "join" the tables together so I can get the earnings from 7 Joined tables, Deductions from 7 joined tables, and the same for the remaining 3 table types. Has anyone tackled a problem like this? I am thinking it might be easier to dump it all into sql but i don't have a tool for that so if that is the answer a recommendation would be appreciated.