How do I create a Label when I have multiple qty of items, and multiple labels per each?
Posted on 2014-11-17
I have an access database that I use to print labels for orders. The table contains an order number, item number, Desc. qty ordered, and a label field that identifies how many labels need to be printed for that item (ie, a desk shell that consists of 4 parts, front, sides, and top). I found a good query that lets me print a qty of labels based on the Qty, which works well, but I now need to add in the qty of qty labels as well.
Order Item Desc Qty Labels
12345 xxx123 4-pc Desk Shell 2 4
The sample above would print (1 of 4, 2 of 4, 3 of 4, 4 of 4) twice, total of 8 labels.
To get the repeat based on the Qty, I am using a CountTable (just a single column from 1-1000), with a query criteria of <=Qty compared to this Count. This works well, but I somehow need to add in this second print variable.
I am guessing that I will need to do make table query, but I have hit a wall here. Any help would be greatly appreciated!! Or maybe what I am doing is just not possible with access.