calculating text

[Guest]

OK this is what I need to do.

I have to print out a number of labels for records in a database. Some of
these records need 3 labels printed, some need twelve. Is there someway to
automate this so I can use a merge and tell the printer how many labels to
print for a certain person. Please help me!

 

[John Vinson]

OK this is what I need to do.

I have to print out a number of labels for records in a database. Some of
these records need 3 labels printed, some need twelve. Is there someway to
automate this so I can use a merge and tell the printer how many labels to
print for a certain person. Please help me!

One sneaky way to do so is to use an auxiliary table, Num, with only
one integer field N. Fill it with values from 0 to the maximum number
of labels you'll ever need (you can be generous, I use 10000).

If your table has a field HowMany indicating the number of labels for
that person, you can base your labels report on a Query; include the
Num table *with no Join line*. Instead, put a criterion on [N] of

< [HowMany]

This "Cartesian join" query will give you 3 copies of the record if
HowMany is equal to 3. You can even use =[N] + 1 & " of " & [HowMany]
as a control source on a textbox on the label to print "2 of 3", if
you wish.

John W. Vinson[MVP]

 

[Guest]

OK,

that helped a bit. I think I mostly understand what you are saying but
could you give me an exact example?? (meaning a step by step that would
be wonderful.

Thanks

OK this is what I need to do.

I have to print out a number of labels for records in a database. Some of
these records need 3 labels printed, some need twelve. Is there someway to
automate this so I can use a merge and tell the printer how many labels to
print for a certain person. Please help me!

One sneaky way to do so is to use an auxiliary table, Num, with only
one integer field N. Fill it with values from 0 to the maximum number
of labels you'll ever need (you can be generous, I use 10000).

If your table has a field HowMany indicating the number of labels for
that person, you can base your labels report on a Query; include the
Num table *with no Join line*. Instead, put a criterion on [N] of

< [HowMany]

This "Cartesian join" query will give you 3 copies of the record if
HowMany is equal to 3. You can even use =[N] + 1 & " of " & [HowMany]
as a control source on a textbox on the label to print "2 of 3", if
you wish.

John W. Vinson[MVP]

 

[Guest]

Guess what!! I understand it now and it works great!! Exactly what I
needed. Thank you soooo much!!

OK this is what I need to do.

I have to print out a number of labels for records in a database. Some of
these records need 3 labels printed, some need twelve. Is there someway to
automate this so I can use a merge and tell the printer how many labels to
print for a certain person. Please help me!

One sneaky way to do so is to use an auxiliary table, Num, with only
one integer field N. Fill it with values from 0 to the maximum number
of labels you'll ever need (you can be generous, I use 10000).

If your table has a field HowMany indicating the number of labels for
that person, you can base your labels report on a Query; include the
Num table *with no Join line*. Instead, put a criterion on [N] of

< [HowMany]

This "Cartesian join" query will give you 3 copies of the record if
HowMany is equal to 3. You can even use =[N] + 1 & " of " & [HowMany]
as a control source on a textbox on the label to print "2 of 3", if
you wish.

John W. Vinson[MVP]

 

[John Vinson]

Guess what!! I understand it now and it works great!! Exactly what I
needed. Thank you soooo much!!

<g> Glad to have pointed you in the right direction - and even gladder
that you took the opportunity to figure it out on your own! Good luck.

John W. Vinson[MVP]

 

[Guest]

OK...so I have another question now. Is there anyway that I can make a page
break after the certain number of labels have printed off for that certain
record?? Meaning I do not want the same contact name/record on the same
sheet of labels.

???

 

[John Vinson]

OK...so I have another question now. Is there anyway that I can make a page
break after the certain number of labels have printed off for that certain
record?? Meaning I do not want the same contact name/record on the same
sheet of labels.

That I don't understand at all. You want one sheet of labels for each
contact name, if there is more than one for that contact? Wastes a lot
of paper!!!

You could - I guess - sort by N as the first field in the sort order
in the Report's Sorting and Grouping dialog, and put a page break in
the Group Footer for N. This would print all N=0 records on one page
(or series of pages), then all of the N=1 records, and so on.

John W. Vinson[MVP]

 

[Guest]

That worked perfectly. And for each contact there are usually 12 -30 labels,
so we will not be wasting a lot of paper, but we need to be able to seperate
the pages. Thank you so much for your help...you are a genius!