Label Report

  • Thread starter Thread starter Stephen Doyle
  • Start date Start date
S

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
 
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.
 
Back
Top