Selective print quantities by page?

[mike101338]

Some background on what I am trying to accomplish. We receive in product from
suppliers and enter the receipt into a warehouse management system. From the
ODBC feeds I am gathering the information and am able to generate a report
showing each item received based on the transaction. This report prints out
each page into a barcode format so I can affix a label to the carton.

My problem is the number of cartons we receive for each item under that same
transaction is not consistent. For example, I may receive five part numbers
on the same transaction, but need one label for three, two for another and
six for one.

Any suggestions on how I can require an input of how many labels to print
for the individual page within a report?

Thanks,

Mike

 

[Allen Browne]

You will need a field in your table to hold the number or labels to print
for each record. You can then use this approach to print the labels:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

Presumably your database contains a local table where you import the ODBC
data, so the local table is populated. The quantity-to-print field will be
blank when imported, so the user will need to enter the number of labels
before printing.

That's the only way to reliably print multiple records with different
quantities.