Hi Richard, An order may consist one or many cartons, or pallets. Shipping labels are attached to each unit of shipper with of course relevant information for the delivery. I would like to have the user just input the total number of packages for the order and the shipping labels to print out: 1 of 1, 2 of 2, 1 of (whatever number there is) for each shipping unit. Can you help?
Kind regards Pino
Kevin Robertson
@Reply 3 years ago
Build a query and add all the fields needed for your labels.
Add a Calculated Query Field.
Use this query as the Record Source for your Label Report.
Example formula (modify as required): LabelNum: DCount("*","LabelT","LabelID>=" & [Label]) & " of " & Forms!FormName!FieldName
Note: You must sort by the ID field (descending) for this to work.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
TechHelp.
