Access Labels based on Table Value

[brenttyrrell]

I am really hoping that someone can help me out of this problem I am having.

I have created a database for the purpose of printing labels for manufacturing purposes. I have a table say 'production data' where I am entering the details of the product and the quantity to be manufactured on that day.
I also have a report label template, which will print the label for me based on the days production.
My problem is that the label report only prints one of the label in the report. Obviously as it only prints each record once. However I would like to work out a way to print the quantity of labels based on the 'Qty' column in the same table.

For example

Product P21544 x 5 and P24512 x 2 I want 5 copies of P21544 and 2 copies of P24512. All to be printed on the same report page to use the minimal amount of label paper.
By the way we are using A4 label paper not a continious line of label paper.

I really do hope someone can help me I have tried everything !!!!!

THANKYOU IN ADVANCE ANYONE THAT CAN HELP

[MMcCarthy]

Something like this might work ...

Dim qty As Integer
Dim rptName As String
 
   qty = <How would you find the quantity of the report>
   rptName = <How would you find the name of the report to print>
   DoCmd.OpenReport rptName, acViewNormal
   DoCmd.PrintOut , , , acHigh, qty, NO
   DoCmd.Close acReport, rptName
 

Mary

[brenttyrrell]

I will give it a try. Thanks for your help

[brenttyrrell]

Unfortunately this did not work.
This code printed multiple copies of the same report rather than quantities of the same label on one page based on the table value.

[MMcCarthy]

Unfortunately this did not work.
This code printed multiple copies of the same report rather than quantities of the same label on one page based on the table value.

This may have more to do with your reports page layout.