Avatar of Crimsonwingz
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
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Gustav Brock

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Crimsonwingz

ASKER
Thank you,  I actually tried that just before you responded!  This will work, unfortunately it makes it SUPER slow, so going to have to keep tweaking.
Gustav Brock

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy