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
