How do I include multiple records per label on Access or Word?

[Rani]

I want to print labels with information from more than one record. I've tried
a few different things, but I can only get one record per label. I attempted
the process on an Access report and when that didn't work, I tried a merge on
Word. How do I proceed?

 

[Anne Troy]

In Word, if you have a field name called <Name>, copy it and paste it onto
the same label. In front of the SECOND instance of <Name>, insert a Word
field called <Next Record>. Every time you want <Name> to pull data from the
next row, you need <Next Record> in front of it.

--
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com