You cannot nest NEXT fields nor can you look backwards through the record
set.
See How to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Russell Pascoe wrote:
Thanks for looking at this, it's got me foxed, I feel I'm on the cusp
of working it out, but not quite!
I want to print a document using a database that sometimes
interlinks with the next record. I run a small property business and
would like to automate the contract process. I fill in the database
with all details and then go to print the contract interrogating the
database. Sometimes there is one tenant, sometimes two. So sometimes
I want to put two names on the contract - surely a simple "IF THEN"
statement? i.e.:
First Name ¦ Last Name ¦ Property ¦ Sharing ¦ Rent
John Brown 3234 Yes 250
Jane Brown 3234 Yes 250
Fred Smith 3235 No 230
So what I want is to go to the first record, get John Brown's name,
which is easy, but then do IF THEN ELSE, IF Sharing = "Yes" "Next
Record First_Name Last_Name" "." But I can't seem to get the syntax
right and am producing nonsense all over the place.
If you know how to help me, I would be very grateful!
Thank you!
Russell.