January 6th, 2009
Table calculations seem much different in 2000 then previous versions. I am apparently missing something suble that prevents it from working for me. I have created a table (this is in a form) in which 3 columns are numeric and require calculations. I bookmarked (<> ) the two cells that I want to use and put the formula in the 3rd thus:
Hours Rate Amount
=product(hours1,rate1)
The 'Hours' column is a number field to be filled in by the user. The 'Rate' field is a constant on the form and the 'Amount' column is the formula. I currently have two problems I don't understand.
1) When the 'Hours' field is filled in, the corresponding 'Amount' field is not automatically updated. There are check boxes in the properties for when a maco is executed but not updates. At least not that I can find.
2) When I manually update the 'Amount' field (right click - update) I get an error telling me 'Hours1' is an unknown bookmark.
Can anyone point me in the right direction on this? Thanks.Searching support.microsoft.com for the keywords 'table formula bookmark' and restricting the search to Word 2000 yields multiple KB entries, some of which refer to known problems with bookmarks and formulas in tables. For more, see http://support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&withinResults=&QuerySource=gASr_Query&Product=wrd20&Queryc=bookmark+formula+table&Query=bookmark+formula+table&KeywordType=ALL&maxResults=25&Titles=false&numDays=#If you have any other info about this subject , Please add it free.# |
|
Posted in weletomylife.com | edit
