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]
|