troubleshooting Question

How do I create a Label when I have multiple qty of items, and multiple labels per each?

Avatar of Crimsonwingz
Crimsonwingz asked on
Microsoft Access
3 Comments1 Solution201 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros