Label Report

[Stephen Doyle]

Using the access 2000 wizard I have created a contact database. I now need
to create a label report using the company name field, so that it shows the
company and their addresses only once despite the multiple names under that
company. How do I create the query?


Cheers
Stephen

 

[Al Campagna]

Stephen,
You should have a main table (tblCompanies) of companies, and a table (tblContacts) of
Contacts, related via some unique key field (ex. CompanyID), to create a One to Many
relationship betweem Companies and Contacts.
To create one label for each Company, the report should be based on tblCompanies only.