creating multiple data rows, for labels based on a cell value
I have a need to produce multiple labels (probably via a mail merge (or something). my sticking point is that the number of labels will vary based on a cell value for the given row(i.e quantity)
I am assuming there is a way within a loop or some other method, but I am not finding such an example in my searches. currently, all of the data is in Excel-but could export to Access if a solution within Access is needed for more in-depth code
Sample data below with some explanation
item quantity # of labels needed( quantity*2)
101 1 2
102 5 10
|