View Single Post
 
Old 06-20-2015, 11:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

What you need to add to your DATABASE field is the mergefield condition that needs to be satisfied to generate the output. For example, you might need to replace:
WHERE [Linktoclosing]=30
with:
WHERE [Linktoclosing]={MERGEFIELD Closing}
or add an AND condition like the one at the end of the quoted content in my previous post.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote