Multiple mailing labels single record

[dta5150]

I have a Access 2003 database which contains 160 records of names and
addresses. I have a need to search my database by last name, first name and
locate the record and then need to print a full page of mailing labels.
I'm using Avery 5160 labels which are three accross and 10 rows totaling 30
labels. Basically, I need to print an address label 30 times to fill the
whole page with same record containing name and address. So far I have
created a report using the label wizard which will print 30 different records
per page.

It sounds like I need to use a query function and tie it in to my report. My
level is novice. Could someone please walk me through the steps.

Example:

John Doe
123 Maple St
Chicago, IL 00000

I need this printed 30 times same record.

Thank you for your support

 

[Al Campagna]

dta,
Create a table (ex. tblLabelCount) that has only one numeric integer field (ex.
LabelCount)
Populate that table with numbers 1 thru 50 (or whatever max number of labels you might
like)
In the query behind you label report, bring that new table in, and DO NOT create any
relationship between your Address table and the LabelCount table.
That will create a Cartesian relationship where each label record will be repeated for
each number in the Count table.
Let's say you have just one label for John Doe. The Cartesian will cause this...
John Doe 1
John Doe 2
John Doe 3 etc... etc... to the tblLabelCount max value.

Now just limit (criteria) the LabelCount field with a parameter like < 31, and John Doe
will repeat 30 times.
Limit it by <11 and you'll get 10 John Doe labels.

Usually this label setup is called from a form, where the specific address (via the key
field for that address) limits the query to that record/s, and a text control on that form
with "how many labels" is filled in by the user.
The report query would then use
=Forms!frmYourForName!HowMany
as the criteria against LabelCount.

 

[dta5150]

In the query behind you label report, bring that new table in, I need help
on this step. How do I perform this?

Usually this label setup is called from a form, where the specific address
(via the key

field for that address) limits the query to that record/s, and a text control on that form
with "how many labels" is filled in by the user.
The report query would then use
=Forms!frmYourForName!HowMany
as the criteria against LabelCount.

In addition I could use some help here as well.

Thank you sorry for the novice pace here but your help is much appreciated
and I fill I'm getting closer.

dta,
Create a table (ex. tblLabelCount) that has only one numeric integer field (ex.
LabelCount)
Populate that table with numbers 1 thru 50 (or whatever max number of labels you might
like)
In the query behind you label report, bring that new table in, and DO NOT create any
relationship between your Address table and the LabelCount table.
That will create a Cartesian relationship where each label record will be repeated for
each number in the Count table.
Let's say you have just one label for John Doe. The Cartesian will cause this...
John Doe 1
John Doe 2
John Doe 3 etc... etc... to the tblLabelCount max value.

Now just limit (criteria) the LabelCount field with a parameter like < 31, and John Doe
will repeat 30 times.
Limit it by <11 and you'll get 10 John Doe labels.

Usually this label setup is called from a form, where the specific address (via the key
field for that address) limits the query to that record/s, and a text control on that form
with "how many labels" is filled in by the user.
The report query would then use
=Forms!frmYourForName!HowMany
as the criteria against LabelCount.

I have a Access 2003 database which contains 160 records of names and
addresses. I have a need to search my database by last name, first name and

[quoted text clipped - 17 lines]

Thank you for your support

 

[Al Campagna]

Your label report should be based on a query. That query should
already contain the address table that generates your labels.
Using query design grid, use Show Table, and select the new table
you created for the Label Count and drag into the design grid.
Now place the LabelCount field on the grid. Now you can expirement
with different criteria values against LabelCount to see how you can
generate multiple copies of a label.

Just try to get that working before we try to go any further.

Al Campagna

In the query behind you label report, bring that new table in, I need help
on this step. How do I perform this?

Usually this label setup is called from a form, where the specific address
(via the key

field for that address) limits the query to that record/s, and a text control on that form
with "how many labels" is filled in by the user.
The report query would then use
=Forms!frmYourForName!HowMany
as the criteria against LabelCount.

In addition I could use some help here as well.

Thank you sorry for the novice pace here but your help is much appreciated
and I fill I'm getting closer.

dta,
Create a table (ex. tblLabelCount) that has only one numeric integer field (ex.
LabelCount)
Populate that table with numbers 1 thru 50 (or whatever max number of labels you might
like)
In the query behind you label report, bring that new table in, and DO NOT create any
relationship between your Address table and the LabelCount table.
That will create a Cartesian relationship where each label record will be repeated for
each number in the Count table.
Let's say you have just one label for John Doe. The Cartesian will cause this...
John Doe 1
John Doe 2
John Doe 3 etc... etc... to the tblLabelCount max value.

Now just limit (criteria) the LabelCount field with a parameter like < 31, and John Doe
will repeat 30 times.
Limit it by <11 and you'll get 10 John Doe labels.

Usually this label setup is called from a form, where the specific address (via the key
field for that address) limits the query to that record/s, and a text control on that form
with "how many labels" is filled in by the user.
The report query would then use
=Forms!frmYourForName!HowMany
as the criteria against LabelCount.

I have a Access 2003 database which contains 160 records of names and
addresses. I have a need to search my database by last name, first name and

[quoted text clipped - 17 lines]

Thank you for your support