Print multiple labels per record

[Leslie]

I am trying to print multiple labels based on a count that is stored in my
table per record. Anyone have any suggestions. (i.e. rec1 count=2; rec2
count=4, etc). I would like to print 2 labels for rec1 and then 4 labels for
rec2.

 

[Duane Hookom]

I generally create a table of numbers:
tblNums
==============
Num ( numeric field with values 1, 2, 3, 4,...)
Add this table to your report's record source query. Don't join this table
to other tables. Set the criteria under the [Num] field to
<=[Count Field]
This should create multiple records based on your count field.

 

[Leslie]

Thanks to Duane, I actually looked at a previous post that you replied to
and did what you suggested. It worked great and thanks for your speedy reply.
--
Leslie

I generally create a table of numbers:
tblNums
==============
Num ( numeric field with values 1, 2, 3, 4,...)
Add this table to your report's record source query. Don't join this table
to other tables. Set the criteria under the [Num] field to
<=[Count Field]
This should create multiple records based on your count field.
--
Duane Hookom
Microsoft Access MVP

I am trying to print multiple labels based on a count that is stored in my
table per record. Anyone have any suggestions. (i.e. rec1 count=2; rec2
count=4, etc). I would like to print 2 labels for rec1 and then 4 labels for
rec2.

 

[Lauri Komita]

I'm trying to print multiple labels of a query based on a predetermined field. I'm trying to do what you say but it says "Set the criteria under the [Num] field to ..."
and then doesn't say what to set it to. Thanks, Lauri

I am trying to print multiple labels based on a count that is stored in my
table per record. Anyone have any suggestions. (i.e. rec1 count=2; rec2
count=4, etc). I would like to print 2 labels for rec1 and then 4 labels for
rec2.

tblNums
==============
Num ( numeric field with values 1, 2, 3, 4,...)
Add this table to your report's record source query. Don't join this table
to other tables. Set the criteria under the [Num] field to
<=[Count Field]
This should create multiple records based on your count field.
--
Duane Hookom
Microsoft Access MVP


"Leslie" wrote:

 

[Allen Browne]

Here's an explanation of how to go about it:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to print multiple labels of a query based on a predetermined
field. I'm trying to do what you say but it says "Set the criteria under
the [Num] field to ..."
and then doesn't say what to set it to. Thanks, Lauri

I am trying to print multiple labels based on a count that is stored in
my
table per record. Anyone have any suggestions. (i.e. rec1 count=2; rec2
count=4, etc). I would like to print 2 labels for rec1 and then 4 labels
for
rec2.

tblNums
==============
Num ( numeric field with values 1, 2, 3, 4,...)
Add this table to your report's record source query. Don't join this
table
to other tables. Set the criteria under the [Num] field to
<=[Count Field]
This should create multiple records based on your count field.
--
Duane Hookom
Microsoft Access MVP


"Leslie" wrote:

On Thursday, February 08, 2007 6:35 PM Lesli wrote:
Thanks to Duane, I actually looked at a previous post that you replied
to
and did what you suggested. It worked great and thanks for your speedy
reply.
--
Leslie


"Duane Hookom" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: Google Analytics
http://www.eggheadcafe.com/tutorial...85f8fda2442/book-review-google-analytics.aspx