Print x number of labels based on field value 1

[GPM4663]

Hi Everyone,
I have a report that I use to print labels for about 100 products. There are 6 labels per page but I need a different number of labels for each product. The label details and the number of labels per product are stored in a table which I have been using as a source of the report but the way it is set up I only get 100 labels because there are 100 records - one for each product. Is there a way for me to repeat a label based on the value in the NumberOfLabels field in the table?

thanks in advance for any help,

GPM

 

[PWise]

Create A numbers Table
1 field from 1 till......

use this sql

Select *
from products
inner join numbers
on numbers.numberid<=products.numbersOfLables

 

[GPM4663]

Pwise, you are a very clever person. Worked like a treat, thanks a lot.

Cheers

GPM