Print multiple labels in Access based on qty value in a field?

[Shreniuk]

For example I have one row opf data but the quantity is 5, so I would like 5
labels to print.

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to build a query that gives you 5 copies of the
record where you want 5 labels, where the number of labels is in one of the
fields.

It also explains why another common approach does not work reliably (using
the events of the report.)

 

[Shreniuk]

Thank you very much.

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to build a query that gives you 5 copies of the
record where you want 5 labels, where the number of labels is in one of the
fields.

It also explains why another common approach does not work reliably (using
the events of the report.)

 

[Don]

Allen, have tried your solution to thisproblem and get
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables. (Error 3071)"

I have renamed my fields as per your instruction.

Here is qry I'm using as record source:SELECT
tblConsignments1.ConsignmentID, tblConsignments1.ConsignmentDate,
tblConsignments1.ShipperID, tblConsignments1.ConsignmentNumber,
tblConsignments1.AccountNumber, tblConsignments1.ShipName,
tblConsignments1.ShipAddress1, tblConsignments1.ShipAddress2,
tblConsignments1.ShipCity, tblConsignments1.ShipState,
tblConsignments1.ShipPostCode, tblConsignments1.NumberOfParcels,
tblCount.CountID
FROM tblConsignments1, tblCount
WHERE
(((tblConsignments1.ConsignmentID)=[forms]![frmConsignments1].[ConsignmentID])
AND
((tblConsignments1.AccountNumber)=[forms]![frmConsignments1].[Accountnumber])
AND ((tblCount.CountID)<=[NumberOfParcels]));

What am I missing here?

 

[Don]

Allen, ever mind, found the problem........ My NumberOfParcels was a text
field!!
--
Don, Sydney Australia

Allen, have tried your solution to thisproblem and get
"This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables. (Error 3071)"

I have renamed my fields as per your instruction.

Here is qry I'm using as record source:SELECT
tblConsignments1.ConsignmentID, tblConsignments1.ConsignmentDate,
tblConsignments1.ShipperID, tblConsignments1.ConsignmentNumber,
tblConsignments1.AccountNumber, tblConsignments1.ShipName,
tblConsignments1.ShipAddress1, tblConsignments1.ShipAddress2,
tblConsignments1.ShipCity, tblConsignments1.ShipState,
tblConsignments1.ShipPostCode, tblConsignments1.NumberOfParcels,
tblCount.CountID
FROM tblConsignments1, tblCount
WHERE
(((tblConsignments1.ConsignmentID)=[forms]![frmConsignments1].[ConsignmentID])
AND
((tblConsignments1.AccountNumber)=[forms]![frmConsignments1].[Accountnumber])
AND ((tblCount.CountID)<=[NumberOfParcels]));

What am I missing here?

--
Don, Sydney Australia

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

The article explains how to build a query that gives you 5 copies of the
record where you want 5 labels, where the number of labels is in one of the
fields.

It also explains why another common approach does not work reliably (using
the events of the report.)