Number of labels to print

[Stephen]

I have an Orders Database.
It has tables: Customers, Orders, Order Details, etc.

I want to print a specific number of Labels that look as
follows:
__________________________________
| [Customers].[CompanyName] |
| [Customers].[CompanyAddress] |
| [Orders].[ShipDate] |
| [OrderDetails].[ProductName] |
|_________________________________|

The specific number of labels to print will be taken from
the [OrderDetails].[ProductQty] Field
and only records which should print will be those
shipping on the [Orders].[ShipDate]


Any help would be appreciated.

Thank you
Stephen

 

[Allen Browne]

See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
The article explains how to use a Cartesian Product to generate the desired
number of labels.

You can add criteria to your query to print for just one ShipDate.

 

[Stephen]

THANK YOU !!!

-----Original Message-----
See:
Printing a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html
The article explains how to use a Cartesian Product to generate the desired
number of labels.

You can add criteria to your query to print for just one ShipDate.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have an Orders Database.
It has tables: Customers, Orders, Order Details, etc.

I want to print a specific number of Labels that look as
follows:
__________________________________
| [Customers].[CompanyName] |
| [Customers].[CompanyAddress] |
| [Orders].[ShipDate] |
| [OrderDetails].[ProductName] |
|_________________________________|

The specific number of labels to print will be taken from
the [OrderDetails].[ProductQty] Field
and only records which should print will be those
shipping on the [Orders].[ShipDate]


Any help would be appreciated.

Thank you
Stephen

.