label printing

  • Thread starter Pierre Faubert via AccessMonster.com
  • 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)
 
R

Rick B

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
labels.(next record has a different qty)
 
D

Duane Hookom

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top