Print multiple copies of report data 1

[TrekBiker]

My client creates orders each with multiple items, assembling details in a query like this.

Using this to print labels gives just one label for each Order Detail ID. We want instead to print the quantity number of each label, so

8 of Maldon Gold
4 of Oscar Wilde
24 of Captain Bob
etc

Preferably we'd like to print the whole set for any Order ID, not have to work down row by row.

Is this possible?

 

[dhookom]

I would create a table of numbers [tblNums] with a single numeric field [Num] with values of 1 through the highest number you would ever need (or 100* that many). Then add tblNums your report's recordsource and set a criteria under the [Nums] field to <=[Quantity]. Make sure the report has [Order Detail ID] in the sorting so these records all render together.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[TrekBiker]

Top man yet again, Duane, that works a treat. It also improves the existing printing process, which needed each order item to be selected and scanned by a barcode reader, which then initiated printing the required number of labels for just that item. Your alternative will allow the whole set to be printed in one operation.
Also used one of your replies from years ago to someone's question about adding a word count to a form. Perfect solution so thanks for that too.
Ought now to change my Tek-Tips handle to Specialized E-Biker having added this for tough biking days! Concession to the aging process.

 

[dhookom]

Hi “Biker”
I had to leave my Specialized gravel hanging in the garage following a major heart attack June 8 and quadruple bypass. I have put some miles on my stationary bike with Wahoo RGT (similar to Zwift but with free version).

Glad I helped you.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[TrekBiker]

So sorry to hear of your heart problems, hope not restricting your life in any way.

 

[dhookom]

I should be back to 100% but it will take a while.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016