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
158 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 49

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 49

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

808 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