By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,816 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,816 IT Pros & Developers. It's quick & easy.

Printing multiple labels from one record

P: 1
I have an inventory table that come from an other system that I bring into Access that I am try to come up with a way to print multiple labels from one record. in the example below I want to be able to print labels based on the Qty field on the record, in this case 4

BLK ITEMS Item Desc Qty
BREATHING APPARATUS,S 4
1 Week Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,470
First of all you'll need a table for multiples like this and each record should have a field with a number from 1 up to the maximum number of records in the table. We'll call this table [tblMulti] and the Field [RecNum].

When you build your QueryDef you link the two datasets with a Cartesian Join (or Cross Join) and in your WHERE clause you specify that [tblMulti].[RecNum] must be less than or equal to the Quantity Field ([Qty]?) from your dataset.

Something like :
Expand|Select|Wrap|Line Numbers
  1. SELECT [YourTable].*
  2. FROM   [YourTable]
  3.      , [tblMulti]
  4. WHERE  ([tblMulti].[RecNum]<=[YourTable].[Qty])
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.