label printing

  • Thread starter Thread starter Pierre Faubert via AccessMonster.com
  • Start date Start date
P

Pierre Faubert via AccessMonster.com

How do I get labels to print to an amount in a table.
ex. shipping 2 boxes with same info cust, prod, qty,... want 2 labels.(next record has a different qty)
 
Your post makes no sense. Spell it out for us. Use complete sentences.



Pierre Faubert via AccessMonster.com said:
How do I get labels to print to an amount in a table.
ex. shipping 2 boxes with same info cust, prod, qty,... want 2
Click to expand...
labels.(next record has a different qty)
 
I expect the data might be like:
Prod Qty
Partridge 1
Turtle Doves 2
French Hens 3
etc

He would like 3 French Hens, Two Turtle Doves, and 1 Partridge label(s).

Create a table "tblNums" with a numeric field "Num" and values 1 - 12 (or
higher). Add this table to your report's record source query and don't join
it to any other table. Add the Num field to the grid and set its criteria
to:
<=[Qty]
 
Back
Top