Printing variable number of labels

[Lanason]

anyone know a simple way to print a variable number of labels based on a filed in the record - ie field is 60 I need 60 labels. Ideally with an incrementing counter no on each.
thanks in advance - Adrian

 

[SteveSchapel]

Adrian,

Make a table with a single field, Number (Integer) data type, and fill this will numbers 1 to whatever the greatest number of labels you could ever imagine wanting printed at any instance.

Add this table to the query that the labels report is based on, no joins, and in the Criteria of this number field, enter:
<=[TheNameOfTheExistingLabelNumberIndicatorField]

You can add a control to the label design, bound to the number field in this counter table.

 

[Lanason]

Thank Steve - I did think of creating a table with the exact no of labels needed but that solution is so simple and elegant

Thanks

 

[howardgreen]

Steve thanks for sharing the nice information about the table....really helpful