Printing Multiple Labels - with a twist

[ANDREWeire]

Hello.

I have reviewed other answers on this forum but none seem to answer this specific question.... or perhaps I am blind

PROBLEM:

I am creating a MS ACCESS application that will be used to print labels. I have linked the application to allow me to print the labels to our Zebra printer (via Bartender)

However, I want to be able to print via ACCESS as well. However, in bartender I am able to use the "identical copies of label" option and link that to the number of labels needed for each part. This information is held on the access database.

Solutions have been posted that would allow me to specify the number of copies of each label but only globally. I need the system to look at each line in the query and determine the number of copies from there.

Is this possible? If not via the print function would this be possible to achieve by creating a temporary table?

Any help appreciated.

 

[ANDREWeire]

Have found the solution....

Have used a fix offerred by MS on their website... I run a query that creates the proper quantity for each record and then point the label at that.