View Single Post
 
Old 01-02-2018, 08:09 AM
josbor01 josbor01 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 2
josbor01 is on a distinguished road
Default 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
Reply With Quote