Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 10-11-2014, 08:36 PM
macropod's Avatar
macropod macropod is offline Using skip record as well as if, then, else Windows 7 64bit Using skip record as well as if, then, else Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Since you already have the SKIPIF test, I can't see the point of the further IF test. After all, the record will never appear if { MERGEFIELD Boy4 } is empty.

I also can't follow your IF field's syntax; it's spacing and quote characters are all over the place - you either have too many or too few quotes and too few spaces. It should be something like:
{ IF {MERGEFIELD Boy4 }<> "" "Boy Aged 4: {MERGEFIELD Boy4 }" "" }
or, at an absolute minimum:
{IF{MERGEFIELD Boy4}<> "" "Boy Aged 4: {MERGEFIELD Boy4}"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using skip record as well as if, then, else Transpose cells and skip? ItsjustB Excel 1 01-09-2013 08:53 AM
Using skip record as well as if, then, else skip to next sentence? moreenz Word 3 08-16-2012 02:41 PM
Footer to Start on Page 1 - skip TOC SQLUSA Word 4 08-12-2012 11:36 AM
avoid duplicete record and merge the record with the existed record hemant.behere Excel 0 01-10-2012 02:53 AM
Using skip record as well as if, then, else skip duplicate letters karen h Mail Merge 10 03-23-2011 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft