Groups | Search | Server Info | Login | Register

Groups > microsoft.public.access.reports > #15887

Print Labels for Multiple Items with Multiple Quantities

Show all headers | View raw

I have a query that's output list the Item Number, Description and Quantity to be placed into stock.

Example:

ItemNbr   Desc          StockQty
 ABC      Blue Widget   23
 XYZ      Green Widget  120
 123      Red Widget    59

....

 098      White Widget  10

What I would like to do is loop through this query output to print the number of labels for each item based on the StockQty field.

So when the user clicks the Print Label button the query would run and print 23 lables containing the ItemNbr and Desc for item ABC, then it would print 120 labels for item number XYZ and so on until all the labels have been printed.

I have code that will submit the information for each line individually but to save the user time I'd like to submit the data as a batch.

Thank you in advance for any assistance!

Back to microsoft.public.access.reports | Previous | Next | Find similar

Thread

Print Labels for Multiple Items with Multiple Quantities delbert.labo@gmail.com - 2015-11-06 03:42 -0800

csiph-web