Producing Mailing Labels

  • Thread starter Thread starter Debbi
  • Start date Start date
D

Debbi

I have a single table containing company names and
addresses with up to 4 contact names & job titles for
each. I want to create mailing address labels for each
contact at the firm, if that contact exists.

Any ideas as to how to go about this would b gratefully
received :-).

Many thanks
 
Debbi

The simple way to do this would be to start from more-normalized data.
Having repeating fields ("up to 4 ...") in a table may look simple, and may
parallel what you'd do in Excel, but it creates major headaches, requiring
painful contortions to work around and get what you're requesting.

Any chance you can change the table design to a two-table structure? First
table has company info, second table has company X contact info ... but only
ONE contact per row. In your version, there's no way to know how many
contacts until you investigate each column. The two table version has as
many rows in that second table as there are contacts, so the query just gets
them all.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top