Macropod,

Thanks for the reply,

Yes, I am running the code on a mailmerge document for labels. I confirmed the <<next record>> was not present in any label space on the document, and since I was only expecting 6 records to be returned, did not format a second page per your instructions...

I built the code from your post using a macro to convert the text to code. This successfully returned the price, label name, and sku values from the first record in my dataset but did not progress to the next record when the specified three iterations from the quantity field where reached.

Is there a way to step through the mail merge process to confirm the QTY actually set to the correct value and counts down as expected, and a next record is retrieved when QTY = 0?

Dave