Printing Labels (Report) with Multiple Quantities within the same record

[bioluis1]

Hi all,

I'm trying to generate labels for Boxes in Ms Access through a form where I can define "Qty of boxes" and "Qty of Pieces per Box" and have them print out accordingly.

For example, with the parameters on the table below, I'm expecting to have the form print out 2 labels with a 50 Pcs per box field, and another 2 labels with a 100 pcs per box field (4 labels in total) having a global counter print out on each label (1/4, 2/4...4/4)

Box Qty	Pcs per Box
2	50
2	100

I have already designed a form that can provide a counter but only for one "Box Qty" and "Pcs Per Box" combination, the challenge I'm having is adding 2 or more "Box Qty" and "Pcs Per Box" combinations.



Attached is an image of the form Im envisioning with the desired report output.

Many Thanks!

[June7]

Not tested but see if this helps http://allenbrowne.com/ser-39.html