I am merging info from an access database into a word document. One item I am merging is interest rates on certain investments. Some investments have designated interest rates and some are blank. This is my mergefield code right now:
{IF{MERGEFIELD INTEREST RATE} = 0 " "}{={MERGEFIELD INTEREST RATE}*100 \# 0.00%; -0.00%;}
The second part with the computation and field code switches works perfectly, but when there is no interest rate available and it is pulling a blank field, it gives me "syntex error" on my document. Any suggestions? Thanks! Jaree
{IF{MERGEFIELD INTEREST RATE} = 0 " "}{={MERGEFIELD INTEREST RATE}*100 \# 0.00%; -0.00%;}
The second part with the computation and field code switches works perfectly, but when there is no interest rate available and it is pulling a blank field, it gives me "syntex error" on my document. Any suggestions? Thanks! Jaree
