Solved

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

Posted on 2014-11-17
3
160 Views
Last Modified: 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.

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
0
Comment
Question by:Crimsonwingz
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40448067
You can add the CountTable once more, Again with no joins.
It will be aliased CountTable_1 or you can apply your own alias.

The first CountTable you filter for <= Qty (as you do now), the other for <= QtyOfQty

/gustav
0
 

Author Comment

by:Crimsonwingz
ID: 40448346
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.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40448554
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
1

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question