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



"Duane Hookom" wrote:

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


"Pendragon" wrote in message
...
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