Varying multiple labels in a report

[Guest]

I have a table of accounts (1 record per account) for which I need to print a
labels report with multiple labels for each account, the number of which
varies from account to account and is drawn from a field called NumbOfLabels.

I have previously used article Q299024 to skip and duplicate labels for a
*single* account, but now need to generate a batch of labels for multiple
accounts. Any ideas on how I can modify the functions to reference the
specific value in NumbOfLabels? Specifically, it's Function LabelSetup(),
and it works great if there is user input for the number of labels. But my
situation is that each account has a different number of labels to print, and
I would like to be able to do them in batch.

Any help is truly appreciated!

Ross

 

[Duane Hookom]

I would create a table to numbers with a single numeric field (tblNums.Num)
and add records from 1 to your maximum number of labels.

Add this table to your report's record source and don't join it to any other
table. Set the criteria under the Num field to:
<=[NumbOfLabels]

 

[CevinMoses]

Duane,
Same problem, but it's not working for me, though I've done something like
this before. I'm printing labels, each which has to be individually numbered
from 1 to [QTY]. I tried your solution (below). If I put the condition in,
then the query doesn't return anything; it stays in Design View. However, if
I take the condition out, then the query returns what I would expect it to:
255 versions of each record.

tPkGIDNumber.Number has 255 records numbered sequentially 1-255, like the
tblNums.Num you described below.

SELECT
qQuickReceive.ShipToID,
qQuickReceive.AddressName,
qQuickReceive.PartNo,
qQuickReceive.QTY,
qQuickReceive.ShipperNo,
tPkgIDNumber.Number

FROM tPkgIDNumber, qQuickReceive

WHERE tPkgIDNumber.Number >= qQuickReceive.QTY

Thanks,
Cevin

I would create a table to numbers with a single numeric field (tblNums.Num)
and add records from 1 to your maximum number of labels.

Add this table to your report's record source and don't join it to any other
table. Set the criteria under the Num field to:
<=[NumbOfLabels]

--
Duane Hookom
MS Access MVP

I have a table of accounts (1 record per account) for which I need to print
a
labels report with multiple labels for each account, the number of which
varies from account to account and is drawn from a field called
NumbOfLabels.

I have previously used article Q299024 to skip and duplicate labels for a
*single* account, but now need to generate a batch of labels for multiple
accounts. Any ideas on how I can modify the functions to reference the
specific value in NumbOfLabels? Specifically, it's Function LabelSetup(),
and it works great if there is user input for the number of labels. But
my
situation is that each account has a different number of labels to print,
and
I would like to be able to do them in batch.

Any help is truly appreciated!

Ross

 

[Duane Hookom]

I think you want your criteria to be
WHERE tPkgIDNumber.Number <= qQuickReceive.QTY


--
Duane Hookom
MS Access MVP

Duane,
Same problem, but it's not working for me, though I've done something like
this before. I'm printing labels, each which has to be individually
numbered
from 1 to [QTY]. I tried your solution (below). If I put the condition
in,
then the query doesn't return anything; it stays in Design View. However,
if
I take the condition out, then the query returns what I would expect it
to:
255 versions of each record.

tPkGIDNumber.Number has 255 records numbered sequentially 1-255, like the
tblNums.Num you described below.

SELECT
qQuickReceive.ShipToID,
qQuickReceive.AddressName,
qQuickReceive.PartNo,
qQuickReceive.QTY,
qQuickReceive.ShipperNo,
tPkgIDNumber.Number

FROM tPkgIDNumber, qQuickReceive

WHERE tPkgIDNumber.Number >= qQuickReceive.QTY

Thanks,
Cevin

I would create a table to numbers with a single numeric field
(tblNums.Num)
and add records from 1 to your maximum number of labels.

Add this table to your report's record source and don't join it to any
other
table. Set the criteria under the Num field to:
<=[NumbOfLabels]

--
Duane Hookom
MS Access MVP

I have a table of accounts (1 record per account) for which I need to
print
a
labels report with multiple labels for each account, the number of
which
varies from account to account and is drawn from a field called
NumbOfLabels.

I have previously used article Q299024 to skip and duplicate labels for
a
*single* account, but now need to generate a batch of labels for
multiple
accounts. Any ideas on how I can modify the functions to reference the
specific value in NumbOfLabels? Specifically, it's Function
LabelSetup(),
and it works great if there is user input for the number of labels.
But
my
situation is that each account has a different number of labels to
print,
and
I would like to be able to do them in batch.

Any help is truly appreciated!

Ross