View Single Post
  #1  
Old September 12th, 2005, 08:40 PM
Pendragon
external usenet poster
 
Posts: n/a
Default Varying multiple labels in a report

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