I've been posting questions here the last week, but if you don't know my
situation:

I have a "Print Labels" button on the subform that sends the appropriate box
information on the subform to a report called "Labels." This is how we are
going to print our shipping labels. I also have a label which is a report
called "Destination_Label" that contains the address where the shipment is
to be delivered. While each box label in the "Label" report is unique, the
destination label is the same for all the boxes in that shipment.

What I would like to do is print 2 copies of the box label and 1 copy of the
destination label in that order. For example, if I have 3 boxes on my
subform, I would like press a button that would cause the labels to print
like this:

Box Label 1, Box Label 1, Destination Label, Box Label 2, Box Label 2,
Destination Label, Box Label 3, Box Label 3, Destination Label

We print a lot of labels and it would be easier to apply the labels in order
instead of dealing with 2 stacks of labels. Again, each box label is unique,
but the destination label is the same for the entire shipment.

Is something like this possible? Help would be greatly appreciated.

Thanks,

Chad

Hi:
Use 3 subreports
The first 2 point to the BoxLabel Table (or query).
You need to create a table with the destination label with as many
duplicate records as there are boxes.
Then point the third subreport to that.

Good Luck
Ira Solomon


On Sun, 03 Apr 2005 22:09:38 GMT, "ChadDiesel"
<shaqattack1992-newsgroups (AT) yahoo (DOT) com> wrote: