Print multiple labels per record

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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: