Name Badge Label Problem

  • Thread starter Thread starter Bob Bower
  • Start date Start date
B

Bob Bower

Greetings All…

I am using ACCESS 2002 and Windows XP Pro.

For a trade show I want to put exhibitor names on Avery 5392 labels. There
are 250 companies, and each is a single record. Within each record I have
twenty “First Name” fields and twenty “Last Name” fields. All are different
individuals.

I am stumped on how to create a report that will print individual names, one
per badge, grouped by company name, for all the names on the credential
list.

I’m probably over my head.



Thanks in advance,



Bob B
 
I would take the time to normalize your tables so that you have a table of
companies and a table of individuals that relates to the companies. If a
company has 17 individuals, this would create 17 records in the individuals
table. You could add records to your individuals table by appending the
company code field and pairs of name fields (two at a time).
 
Separate tables is easy. Setting up the name fields on the label so I can
print individual names, one per label is where I am lost.
The wizard presents only one label in design mode. The label page when
printed has six labels. I can put the name fields for only one pair of
fields on the label in design mode. They are "Firstname1, Lastname1". The
report prints only the first name on the list for each company on each
label, as it should. I need to have a label print for all twenty individuals
on the credential list for each company. Each of the twenty individuals has
a separate field for first and last names. "Firstname2" Lastname2" and so
on. The other fields on the label are "Company", "City", "State".
Not every company will require 20 credentials, but we are set to deal with
those that will. The labels need to be printed and sorted by company so they
can be sent to the company prior to the show.

Bob Bower
 
You totally missed my point that you should have two tables: one for
companies and one for individuals. Your 20 groups of repeating fields is not
normalized and is responsible for your issue.
If you don't want to normalize then create a report where the detail section
is sized for 20 labels. Drop and drag your fields around to where they need
to be printed. You will have blank labels where you don't have 20
individuals in a company but this is the cost of not having normalized
tables.
Normalize and your problem goes away.

--
Duane Hookom
MS Access MVP


Bob Bower said:
Separate tables is easy. Setting up the name fields on the label so I can
print individual names, one per label is where I am lost.
The wizard presents only one label in design mode. The label page when
printed has six labels. I can put the name fields for only one pair of
fields on the label in design mode. They are "Firstname1, Lastname1". The
report prints only the first name on the list for each company on each
label, as it should. I need to have a label print for all twenty individuals
on the credential list for each company. Each of the twenty individuals has
a separate field for first and last names. "Firstname2" Lastname2" and so
on. The other fields on the label are "Company", "City", "State".
Not every company will require 20 credentials, but we are set to deal with
those that will. The labels need to be printed and sorted by company so they
can be sent to the company prior to the show.

Bob Bower
Click to expand...
 
Check out Roger Carlson's web site for a download
www.RogersAccessLibrary.com.


NormalizeDenormalize2k.mdb (37 KB) ( intermediate ) Access 2000 DAO
It illustrates how to take a table which has fields like Value1, Value2,
Value3,... and writes them into a table which has one field (Value) with
each of the values in a new record
 
Thank you very much. I will head over there right now.

I'll report back on my success... Hopefully

Bob Bower
 
Back
Top