creating multiple labels from a query or table

[sbodman]

I work in a steel product fabrication company.
Many orders we fulfill require we provide a waterproof tag for each product with information as follows:
Sales order #
Internal Tag #
Item Description / Identifier
ISO #
# units

All this information is already in a spreadsheet with each field easily imported into Access as a table.



I would like to have a routine / macro such that Access will look at each item, determine how many tags will be needed for each item by looking a the "# Units" field, then producing the correct number of labels for each item with the related information.

It would seem simple to do, but I'm spinning my wheels. any guidance would be greatly appreciated as doing this iterative process by hand is very time consuming.

Thanks in advance!

[June7]

Review:

https://www.accessforums.net/program...1-a-43232.html

https://www.accessforums.net/reports...ord-37535.html