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]