If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using a value to produce X number of records
Hey all,
I have a string in which i want to drop variables into and produce a large list of these. The problem is the last variable i am working with. This digit represent the number of records i want to create. ie: State Type Number AAA Car 2 BBB Boat 3 To then produce this merge: AAA Car 1 AAA Car 2 BBB Boat 1 BBB Boat 2 BBB Boat 3 Is this possible? Thanks for any advice Richard |
#2
|
|||
|
|||
Using a value to produce X number of records
Hi Rf,
You can probably manage to do it, using the technique described in this Knowledge Base article http://support.microsoft.com?kbid=211303 HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000 Just increment a "counter" (SET field) and each time you loop, check whether it's greater than that third field, switching when it does. (IOW, instead of checking when the field content changes, check when that number has been exceeded.) I have a string in which i want to drop variables into and produce a large list of these. The problem is the last variable i am working with. This digit represent the number of records i want to create. ie: State Type Number AAA Car 2 BBB Boat 3 To then produce this merge: AAA Car 1 AAA Car 2 BBB Boat 1 BBB Boat 2 BBB Boat 3 Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Using a value to produce X number of records
Thanks, I'll give it a go and see what happens
Richard "Cindy M -WordMVP-" wrote in message news:VA.000099f0.00ec598d@speedy... Hi Rf, You can probably manage to do it, using the technique described in this Knowledge Base article http://support.microsoft.com?kbid=211303 HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000 Just increment a "counter" (SET field) and each time you loop, check whether it's greater than that third field, switching when it does. (IOW, instead of checking when the field content changes, check when that number has been exceeded.) I have a string in which i want to drop variables into and produce a large list of these. The problem is the last variable i am working with. This digit represent the number of records i want to create. ie: State Type Number AAA Car 2 BBB Boat 3 To then produce this merge: AAA Car 1 AAA Car 2 BBB Boat 1 BBB Boat 2 BBB Boat 3 Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|