|
| 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
January 9th, 2010, 02:30 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Multiple Numbers on ONE Label
I have several thousand labels I need to print. I would like to put up to 4
part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 
|
|
#2
January 9th, 2010, 11:44 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Numbers on ONE Label
See:
Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Quantity field that tells you how many labels you need for each record. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234
|
|
#3
January 11th, 2010, 09:58 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Numbers on ONE Label
I have used your method in the past with great success. This time something
a little different. Instead of printing 100 labels, I want to print 25 labels with 4 Different numbers on each label. I am going to put one label on a box and then put those 4 parts in that box. Can this be done? "Allen Browne" wrote: See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Quantity field that tells you how many labels you need for each record. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 .
|
|
#4
January 12th, 2010, 02:42 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Numbers on ONE Label
The data has to come from somewhere. If you want to specify which parts go
into which boxes, you probably need a related table that holds that information. You can then draw the data from the tables (via a query), and print it. If it's not just a specific range (which could be generated by the Cartesian product), it has to be specified. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have used your method in the past with great success. This time something a little different. Instead of printing 100 labels, I want to print 25 labels with 4 Different numbers on each label. I am going to put one label on a box and then put those 4 parts in that box. Can this be done? "Allen Browne" wrote: See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Quantity field that tells you how many labels you need for each record. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 .
|
|
#5
January 12th, 2010, 04:36 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Multiple Numbers on ONE Label
I have been unclear in what I want to do. I have a table that stores my Part
Numbers in ONE field [Part]. How do I put one field on a label and get 4 numbers to print on the SAME label? Do I need a subreport which will list all the numbers and if so, how do I limit the 4 max numbers per label? "Allen Browne" wrote: The data has to come from somewhere. If you want to specify which parts go into which boxes, you probably need a related table that holds that information. You can then draw the data from the tables (via a query), and print it. If it's not just a specific range (which could be generated by the Cartesian product), it has to be specified. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have used your method in the past with great success. This time something a little different. Instead of printing 100 labels, I want to print 25 labels with 4 Different numbers on each label. I am going to put one label on a box and then put those 4 parts in that box. Can this be done? "Allen Browne" wrote: See: Print a Quantity of a Label at: http://allenbrowne.com/ser-39.html The article assumes you have a Quantity field that tells you how many labels you need for each record. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "NEWER USER" wrote in message ... I have several thousand labels I need to print. I would like to put up to 4 part numbers on each label (Avery 5164). These labels will placed on boxes that hold product. Some labels may only get 2 or 3 part numbers per label depending on size of the part. My part numbers are classified as S,M,L. Can this be done? Example... ABC123 - small ABC234 - large (max 2 numbers per label) ABC345 - small ABC456 - med (max 3 numbers per label) BCD123 - small BCD234 . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
