I am working on an Access database that was created by someone before me, and I'm having a problem working with some of the data. I have two tables that contain information, one being a list of companies and the other being a list of officers for those companies. The ID columns for the two table match, but there are multiple officer entries for a lot of the companies, on seperate lines in the officer table. What I need to be able to do is combine the two tables so that the officers, or at least up to five to seven show up on the same line as the company information, and I can't/don't want to do it manually because there are over 5000 companies. I have shown an expample below: Companies Table: 5 Name Address Address2 City State Zip Officers Table: 5 Title1 First Name1 Middle1 Last Name1 Position1 5 Title2 First Name2 Middle2 Last Name2 Position2 What I want in the result is: 5 Name Address Address2 City State Zip Title1 First Name1 Middle1 Last Name1 Position 1 Title 2 First Name2 Middle2 Last Name2 Position2 (each line starting with a number is one continuous line.) Thank You if you can help, Matthew Ballard The PCSOFT web site always needs good submissions. If you would like to contribute to the website, send any software tech tips or software reviews to: [log in to unmask]