Print multiple labels per record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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 said:
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


Leslie said:
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.
Click to expand...
Click to expand...
 
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:
Click to expand...
Click to expand...
 
Back
Top