If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Syntax Error in properly working formula??
Hi,
Using Word 2002. I sought assistance in another post with the following formula: { =Sum(Table1 B:B) \# "#,##0.00;- #,##0.00;''" } (Thanks to Greg Maxey). My problem now is that (even though this formula works great) IF I don't update the field before I print the page I get an error: $1,111.00!Syntax Error, " This appears to be because I have my Tools | Options | Print | Update Fields selected. When I de-select the Update Fields option I don't get the error. I have noticed that when I right click the formula and choose Edit Field when I look at the formula it appears as: =SUM(Table1B:B) That is, no space between Table 1 and B:B. No matter how many times I put it in, it is automatically removed. Perhaps it's supposed to? Is this enough clues for someone to help? Thanks |
#2
|
|||
|
|||
Syntax Error in properly working formula??
Greg will be away for another week, and as you have not explained what went
on previously or how you are using the field, it is difficult to advise. However if you take a table bookmarked as Table1 and you insert the field you have posted outside the table. It totals column B correctly. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Rita King wrote: Hi, Using Word 2002. I sought assistance in another post with the following formula: { =Sum(Table1 B:B) \# "#,##0.00;- #,##0.00;''" } (Thanks to Greg Maxey). My problem now is that (even though this formula works great) IF I don't update the field before I print the page I get an error: $1,111.00!Syntax Error, " This appears to be because I have my Tools | Options | Print | Update Fields selected. When I de-select the Update Fields option I don't get the error. I have noticed that when I right click the formula and choose Edit Field when I look at the formula it appears as: =SUM(Table1B:B) That is, no space between Table 1 and B:B. No matter how many times I put it in, it is automatically removed. Perhaps it's supposed to? Is this enough clues for someone to help? Thanks |
Thread Tools | |
Display Modes | |
|
|