Duplicating Record for multiple label report output
I am trying to create an output table so that I can print incremental labels. Each label in the output table will have the same record information but it will be numbered based upon a particular field in the record so that when my user selects the address record to use they will also fill in the number of labels required. This needs to generate a 1 of 5, 2 of 5, 3 of 5, etc. on the label output report. I know if I copy the same record 5 times into a table, I get what I need, but I'm not quite sure how to do that automatically with a query or script. Somehow I need to check the LabelQty Field on the record and then cycle that many records into an answer or output table.