Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012

    Question Unanswered: 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.

    Any ideas?

  2. #2
    Join Date
    Dec 2007
    for i from 1 to [labelqty]
    Steven Green - Myrtle Beach, South Carolina USA

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Sep 2012
    Thanks for the quick reply. I figured it had to be pretty simple, I was just missing it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts