Printing labes

Hi all,

I have a problem and I hope one of you can help me with it. I want to
print labels for parcel shipments. I can make the label/report etc. I
have one table with data, each record contains a.o.:
name, address, zipcode etc. and the number of parcels.

Now I want to print as many labels as there are parcels. So if the
value in parcel is 1, then I want it to print 1 label. If the value of
parcel is 3, I want it to print three labels. Etc. etc.
Does anyone have a good idea?

Best regards,
Frans-Jan

FJ wrote:[color=blue]
> Hi all,
>
> I have a problem and I hope one of you can help me with it. I want to
> print labels for parcel shipments. I can make the label/report etc. I
> have one table with data, each record contains a.o.:
> name, address, zipcode etc. and the number of parcels.
>
> Now I want to print as many labels as there are parcels. So if the
> value in parcel is 1, then I want it to print 1 label. If the value of
> parcel is 3, I want it to print three labels. Etc. etc.
> Does anyone have a good idea?[/color]

Yes.

Create a number range (see the Range article on my site, subheading How
to create a range of numbers?).
Create a query based on your parcel table; add the range table/query but
do not join. Instead, apply a criteria: parcel>theNumber (the latter
being the numerical field name of my range object)

The query will produce as many records for one shipment as you have
indicated in parcel.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

Wow Bas!

This works perfect! I have been thinking about how to tackle this
problem for quite some time and couldn't solve it. But your solution is
brilliant...

Thanks again,
Frans-Jan

Wow Bas!

This works perfect! I have been thinking about how to tackle this
problem for quite some time and couldn't solve it. But your solution is
brilliant...

Thanks again,
Frans-Jan

Wow Bas!

This works perfect! I have been thinking about how to tackle this
problem for quite some time and couldn't solve it. But your solution is
brilliant...

Thanks again,
Frans-Jan

FJ wrote:[color=blue]
> Wow Bas!
>
> This works perfect! I have been thinking about how to tackle this
> problem for quite some time and couldn't solve it. But your solution is
> brilliant...[/color]

Be careful that the number of parcels never exceed the highest number
returned by the number query. As now, I think it is 999; but I hope you
won't have to sticker that many parcels ;-)

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea