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