Create multiple labels from one record 1

[thebigcheese]

I am creating a mailing label from an orders table. Within the orders table there is a field "Quantity" and amongst others "Customer".

A customer may order a quantity of say 3. This results in the need to print out 3 labels (to go on a box for mail-out) and on each label print "Box 1 of 3", "Box 2 of 3" etc.

How can this best be achieved, given that there is only one record in the orders table?

 

[IdoMillet]

Create multiple sections for the detail band
and suppress them based on the Quantity.

For example, if quantity is 2 you would suppress
all detail sections beyond the first two.

hth,
- Ido ixm7@psu.edu

 

[Dond12]

Ido's solution works perfectly. However, the limiting factor is that you would have to create a separate details section for each number up to and including the largest number of duplicate labels you might need. This could get cumbersome if, for instance, you might have to print a dozen or so labels for a single customer. Wouldn't you have to create 12 separate details sections, and suppress each one if the record number in the group (or a counter that resets with each new group) is less than a specified maximum of 12? Or am I missing something?

What about creating a set of variables and setting each one to some part of the address and simply keeping the variables the same until the target number of repetitions is reached? Would that work?

 

[IdoMillet]

I suggested the multiple section approach assuming that indeed the largest possible "Quantity" is known and reasonably small.

If that is not true and if you have permission to make simple changes to the database, e-mail me directly so I can explain an alternative solution. It is conceptually more complex but also much "cleaner".

Cheers,
- Ido ixm7@psu.edu