If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Varying multiple labels in a report
I have a table of accounts (1 record per account) for which I need to print a
labels report with multiple labels for each account, the number of which varies from account to account and is drawn from a field called NumbOfLabels. I have previously used article Q299024 to skip and duplicate labels for a *single* account, but now need to generate a batch of labels for multiple accounts. Any ideas on how I can modify the functions to reference the specific value in NumbOfLabels? Specifically, it's Function LabelSetup(), and it works great if there is user input for the number of labels. But my situation is that each account has a different number of labels to print, and I would like to be able to do them in batch. Any help is truly appreciated! Ross |
#2
|
|||
|
|||
I would create a table to numbers with a single numeric field (tblNums.Num)
and add records from 1 to your maximum number of labels. Add this table to your report's record source and don't join it to any other table. Set the criteria under the Num field to: =[NumbOfLabels] -- Duane Hookom MS Access MVP "Pendragon" wrote in message ... I have a table of accounts (1 record per account) for which I need to print a labels report with multiple labels for each account, the number of which varies from account to account and is drawn from a field called NumbOfLabels. I have previously used article Q299024 to skip and duplicate labels for a *single* account, but now need to generate a batch of labels for multiple accounts. Any ideas on how I can modify the functions to reference the specific value in NumbOfLabels? Specifically, it's Function LabelSetup(), and it works great if there is user input for the number of labels. But my situation is that each account has a different number of labels to print, and I would like to be able to do them in batch. Any help is truly appreciated! Ross |
#3
|
|||
|
|||
Varying multiple labels in a report
Duane,
Same problem, but it's not working for me, though I've done something like this before. I'm printing labels, each which has to be individually numbered from 1 to [QTY]. I tried your solution (below). If I put the condition in, then the query doesn't return anything; it stays in Design View. However, if I take the condition out, then the query returns what I would expect it to: 255 versions of each record. tPkGIDNumber.Number has 255 records numbered sequentially 1-255, like the tblNums.Num you described below. SELECT qQuickReceive.ShipToID, qQuickReceive.AddressName, qQuickReceive.PartNo, qQuickReceive.QTY, qQuickReceive.ShipperNo, tPkgIDNumber.Number FROM tPkgIDNumber, qQuickReceive WHERE tPkgIDNumber.Number = qQuickReceive.QTY Thanks, Cevin "Duane Hookom" wrote: I would create a table to numbers with a single numeric field (tblNums.Num) and add records from 1 to your maximum number of labels. Add this table to your report's record source and don't join it to any other table. Set the criteria under the Num field to: =[NumbOfLabels] -- Duane Hookom MS Access MVP "Pendragon" wrote in message ... I have a table of accounts (1 record per account) for which I need to print a labels report with multiple labels for each account, the number of which varies from account to account and is drawn from a field called NumbOfLabels. I have previously used article Q299024 to skip and duplicate labels for a *single* account, but now need to generate a batch of labels for multiple accounts. Any ideas on how I can modify the functions to reference the specific value in NumbOfLabels? Specifically, it's Function LabelSetup(), and it works great if there is user input for the number of labels. But my situation is that each account has a different number of labels to print, and I would like to be able to do them in batch. Any help is truly appreciated! Ross |
#4
|
|||
|
|||
Varying multiple labels in a report
I think you want your criteria to be
WHERE tPkgIDNumber.Number = qQuickReceive.QTY -- Duane Hookom MS Access MVP "CevinMoses" wrote in message ... Duane, Same problem, but it's not working for me, though I've done something like this before. I'm printing labels, each which has to be individually numbered from 1 to [QTY]. I tried your solution (below). If I put the condition in, then the query doesn't return anything; it stays in Design View. However, if I take the condition out, then the query returns what I would expect it to: 255 versions of each record. tPkGIDNumber.Number has 255 records numbered sequentially 1-255, like the tblNums.Num you described below. SELECT qQuickReceive.ShipToID, qQuickReceive.AddressName, qQuickReceive.PartNo, qQuickReceive.QTY, qQuickReceive.ShipperNo, tPkgIDNumber.Number FROM tPkgIDNumber, qQuickReceive WHERE tPkgIDNumber.Number = qQuickReceive.QTY Thanks, Cevin "Duane Hookom" wrote: I would create a table to numbers with a single numeric field (tblNums.Num) and add records from 1 to your maximum number of labels. Add this table to your report's record source and don't join it to any other table. Set the criteria under the Num field to: =[NumbOfLabels] -- Duane Hookom MS Access MVP "Pendragon" wrote in message ... I have a table of accounts (1 record per account) for which I need to a labels report with multiple labels for each account, the number of which varies from account to account and is drawn from a field called NumbOfLabels. I have previously used article Q299024 to skip and duplicate labels for a *single* account, but now need to generate a batch of labels for multiple accounts. Any ideas on how I can modify the functions to reference the specific value in NumbOfLabels? Specifically, it's Function LabelSetup(), and it works great if there is user input for the number of labels. But my situation is that each account has a different number of labels to print, and I would like to be able to do them in batch. Any help is truly appreciated! Ross |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple queries on one Report or Form in Access | JamesA | Setting Up & Running Reports | 2 | December 15th, 2004 03:26 AM |
Creating a mailing labels report using the labels wizard | M. A. van Schaik | Setting Up & Running Reports | 1 | October 6th, 2004 09:57 PM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Concatenating multiple values into a single field on a report | Kevin | Running & Setting Up Queries | 8 | July 16th, 2004 03:31 PM |
How to print an Access Report multiple times, w/ different headers | Dave Corun | Setting Up & Running Reports | 3 | June 2nd, 2004 02:31 AM |