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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example I have one row opf data but the quantity is 5, so I would like 5
labels to print.
 
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.)
 
Thank you very much.

Allen Browne said:
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.)
Click to expand...
 
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?
 
Allen, ever mind, found the problem........ My NumberOfParcels was a text
field!!
--
Don, Sydney Australia


Don said:
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


Allen Browne said:
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.)
Click to expand...
Click to expand...
 
Back
Top