Show two fields from next record conditional upon one original fie Russell Pascoe 6/15/2007 11:38:00 AM 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.

Re: Show two fields from next record conditional upon one original fie "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 6/15/2007 11:58:13 AM 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" <RussellPascoe[ at ]discussions.microsoft.com> wrote in message news:6B0D56DA-B1A7-47CF-8DE1-114A6ECC2E13[ at ]microsoft.com... [Quoted Text] > 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.

Re: Show two fields from next record conditional upon one original fie "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 6/15/2007 12:03:53 PM 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: [Quoted Text] > 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.