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 10 months 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.