TechHelp

Shipping Labels with count Upload Images Link
Pino Arcuri
50 days ago

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
49 days 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.

Scott Axton
49 days ago

Access Expert 32

Dymo Labels

Access Mailing Label Seminar

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to TechHelp Comments

Subscribe to TechHelp
Get notifications when this page is updated