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

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 :-)

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 :-)