Crimsonwingz
asked on
How do I create a Label when I have multiple qty of items, and multiple labels per each?
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.
Example
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.
Jeff
Example
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.
Jeff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you only combine the ID of the real data and the two counttables it shouldn't be that slow.
This (main) query you could join to other data.
/gustav
This (main) query you could join to other data.
/gustav
ASKER