----- Original Message -----
From: Matthew Ballard <[log in to unmask]>
To: <[log in to unmask]>
Sent: Sunday, July 04, 1999 4:51 PM
Subject: [PCSOFT] MS Access Database Problem


> 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:

You have not explained why you would want to do this.  Making such a
table removes all advantages of using a database in the first place.  If
you need to combine the company data and the officer data for some
purpose, you can do so by creating a query that gives you the set of
records you need.  Try giving us an idea what of this table would do for
you and maybe we can come up with a query that would give you the same
result.

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>