Help with creating and printing labels

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

Please help!
my table has the following fields
- OrderNumber
- OrderDate
- QtyReceived

What I would like to do is create a report to print a
label for each item received.

Exemple:
OrderNumber: PJD0551, OrderDate: 03/14/05, QtyReceived: 5

I would like to print 5 labels with the information as
follows:

Order Number PJD0551 - Date 03/14/05 - Item 1 of 5
Order Number PJD0551 - Date 03/14/05 - Item 2 of 5
Order Number PJD0551 - Date 03/14/05 - Item 3 of 5
Order Number PJD0551 - Date 03/14/05 - Item 4 of 5
Order Number PJD0551 - Date 03/14/05 - Item 5 of 5
 
From a previous reply:
Create a table of numbers "tblNums" with a single integer field "Num". Add
enough number records to the table to meet your max quantity:
1
2
3
4
...
X
Then, add this table to your report's record source. Add the Num field to
the query grid and set its criteria to:
<=[QtyReceived]
This will create X number of identical records that you can display in the
detail section of your report.
 
Back
Top