View Single Post
 
Old 01-13-2012, 04:13 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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

Hi ztag,

The problem is caused by some of the dates in your table's 'Rev. Subst. Compl. Date' column having paragraph breaks following them. Those paragraph breaks are included in the bookmarks - which you then refer to on page 3. Delete the extraneous paragraph breaks in the table and everything should be OK.

FWIW, depending on whether it outputs nothing or an error message (I haven't tested which), your field on page 3 coded as:
{ IF CO_number = 1 "revsubstcompl1." { IF CO_number = 2 { "revsubstcompl2" } { IF CO_number = 3 { "revsubstcompl3" } { IF CO_number = 4 { "revsubstcompl4" } { IF CO_number = 5 { "revsubstcompl5" } { IF CO_number = 6 { "revsubstcompl6" } { IF CO_number = 7 { "revsubstcompl7" } { IF CO_number = 8 { "revsubstcompl8" } { If CO_number = 9 { "revsubstcompl9" } { IF CO_number = 10 { "revsubstcompl10" } { IF CO_number = 11 { "revsubstcompl11" } { IF CO_number = 12 { "revsubstcompl12" } { IF CO_number = 13 { "revsubstcompl13" } { IF CO_number = 14 { "revsubstcompl14" } { IF CO_number = 15 { "revsubstcompl15" } { IF CO_number = 16 " { revsubstcompl16 } ." CHECK INPUTS" }}}}}}}}}}}}}}} }
could be reduced to:
{IF{REF "revsubstcompl{CO_number}" }= "" "CHECK INPUTS" {REF "revsubstcompl{CO_number}"}}
or:
{IF{REF "revsubstcompl{CO_number}" }= "Error!*" "CHECK INPUTS" {REF "revsubstcompl{CO_number}"}}

Similarly, your field coded as:
{ IF CO_number = 16 { IF { =SIGN({ REF scopechangeday16 }) }
= 1 "increased by {=ABS(scopechangeday16)} days." { IF { =SIGN({ REF scopechangeday16 }) }
= -1 "decreased by {=ABS(scopechangeday16)} days." "unchanged." } } }
could be reduced to:
{= scopechangeday16 \# "'increased by '0' day(s)'; 'decreased by '0' day(s)';'unchanged'"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote