create a report with diferent number of copies

[zedtedio]

Hi everyone
i have tried to find out how it's possible to print a report wich number of copies is given from a data field from a table.
Don't know if i'm explaining you right, but i'll give you the example.
i have to print labels for some products. the issue is that the number of labels is diferent for each product, depending the quantity of each reference i have in stock.
i have for example:
ref. A - 3
ref. B - 2
.....
ref. Y -7

how can i print 3 labels for ref. A, etc?

thanx a million

 

[vbaInet]

This is a Reports question and you should have asked it in that section.

Anyway, you need to manipulate the rows in the report using VBA. The only method you need is Me.NextRecord. The idea is, set NextRecord to False if the record counter (i.e. intLine) is not equal to the number required. Else NextRecord = True. Here's a link to make reference to:

http://allenbrowne.com/ser-12.html