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?


Al Campagna

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question