[Russell Pascoe]

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.

[Peter Jamieson]

Off the top of my head, try

{ NEXTIF "{ MERGEFIELD Sharing }" = "Yes" }
}{ IF "{ MERGEFIELD Sharing }" = "Yes|"
"{ MERGEFIELD First_Name } { MERGEFIELD Last_Name }" ""
} whatever text you want regardless of whether there are one or two.

However, it will only work properly if the "Sharing" properties always come
in pairs (not in 1s, 3s etc.)

All the {} need to be the special field braces that you can insert using
ctrl-F9, as usual.

Peter Jamieson
"Russell Pascoe" wrote in message
...
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.

[Graham Mayor]

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.