Thread: [Solved] Syntax Help Needed for Using AND Statement in NEXIF
View Single Post
 
Old 05-06-2011, 10:27 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
Hi Rob,

In that case, you need something like:
{SKIPIF{={IF{MERGEFIELD field1}= "" 0 1}+{IF{MERGEFIELD field2}= "" 0 1}+{IF{MERGEFIELD field3}= "" 0 1}+{IF{MERGEFIELD field4}= "" 0 1}}= 0}
If your mergefields have numeric values, the field code could be simplified somewhat.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote