John,
If I go your route, I would still have turn the one row with four pieces (row 3) into four rows. I had thought of that. What code would I use to accomplish that? IF pieces > 1 THEN ? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Monday, December 21, 2009 7:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: shipping labels Jim, One way to achieved the results you are looking for is to first build a temporary table containing one row of data for each label. The table should contain a column for every item of data that you want to appear on the label plus one auto number column. The auto number column would be used to identify the label as 1 of 6 etc. Then use label designer to produce the labels based on the temporary table. JOhn From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, December 21, 2009 7:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - shipping labels Presently our Bill of lading program prints labels in this manner. Let's say I have three rows of data for a bill of lading as below. Pieces Wgt/pc total Wgt Row one: 1 346 346 Row two: 1 845 845 Row three: 4 400 1600 The Program will print 6 labels; one each for the first two rows and four for the third line. Each label will show 1 of 6, 2 of 6, etc. and the weight as such 1 of 6 wgt 346 2 of 6 wgt 845 3 of 6 wgt 400 4 of 6 wgt 400 5 of 6 wgt 400 6 of 6 wgt 400 What function or command would I use to duplicate this process? Jim
