Printing Product Labels - Batch Printing lots.

[Spam]

At the moment I'm using access to do reporting for my companies sales system - all the data is pulled from our sales sql database via odbc.

Now I have a couple of reports which basically prints out sticky labels to use as price tags. I have this working fine for individual products, however, I'd like to set something up to generate labels for every product that came in on an order.

The query supplying the data to the report looks like this:

PO_no Stock_code description Price qty_recvd
123 234543 Product1 £20.00 5
123 543987 Product2 £3.50 20
123 252352 Product3 £8.50 10

I have the report working fine for one label per product. However I can't figure out how to factor in the quantities to print off more than one label per product. So question is how to I get the report to generate 5 labels for product1, 20 for product2, 10 for product3, etc?

Any help would be appreciated.
Cheers

 

[HiTechCoach]

Here is an example to do what you want.

You can import the table tblLabelQuantity into your database and use in your query like.

... WHERE (((tblLabelQuantity.LabelQuantity)<= [qty_recvd]))

Note: You will NOT create a join between the table tblLabelQuantity and your table. If you will need more that 60 copies, you will have to add additional records to the table tblLabelQuantity for 61, 62, ... to the max number of copies you will need..