Using a value to produce X number of records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RF - 03 Jun 2004 09:13 GMT

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

Reply to this Message

Cindy M -WordMVP- - 03 Jun 2004 16:18 GMT

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
[quoted text clipped - 11 lines]
> 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 :-)

Reply to this Message

RF - 05 Jun 2004 05:42 GMT

Thanks, I'll give it a go and see what happens

Richard

> Hi Rf,
>
[quoted text clipped - 32 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message