Multiple Records into Single Record

[Jake]

Hi All -
I'm in desperate need of some help/direction on this challenge I've
been faced with. I have an excel file that I'm converting over to
Access so I can use it for a marketing campaign this weekend. The
database is basically a list of customer contacts that I need to have
updated online. The database is listed with the following columns:

Account Number, Company Name, Contact Name, Email, Phone, etc;

If the company only has one contact then it's no problem.
Unfortunately most of the companies have 2-4 contacts which means I
have 2-4 records for the same company. What I need to do is take those
additional contacts and merge them into one record with more columns.

Account Number, Company name, Contact 1, Email 1, Phone 1, Contact 2,
Email 2, Phone 2, Contact 3, ....

Can this be done?

Thanks in advance for your help.

-Jake

 

[Sninkle]

Sounds like you should have a Company table with table information and a
Contact table with the mutiple Contact information. You will need to create a
relationship between the two tables.

ex.

Company
-----------
CompanyID (primary key)
AccountNumber
CompanyName

Contacts
-----------
ContactID (primary key)
ContactName
Telephone
Email
CompanyID

 

[Peter Hibbs]

Jake,

As Sninkle says, you need two tables, one for Companies and one for
Contacts. Have a look at the Excel to Access Converter program at :-
http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4
which may be able to do that automatically for you.

HTH

Peter Hibbs.

 

[Jake]

Thanks for the quick reply Peter & Carrie. I understand that I really
need two tables with a one to many relationship to do this properly.
However, due to my web application and the way it was designed I need
to have all of this contact information in one record. If my deadline
for this project wasn't so soon then I could possibly look at changing
the web app but unfortunately I don't have much time.

That being said, am I stuck going record by record and moving the data
manually to make this work?

Thanks again for your help!
-Jake