Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / December 2004

Tip: Looking for answers? Try searching our database.

How do you calculate totals in Word 2000?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChiefNewB - 30 Dec 2004 16:45 GMT
Would like to know if it is possible and if so how to automatically calculate
the totals for a time card template.
Greg Maxey - 30 Dec 2004 17:33 GMT
CheifNewB,

To automate the calculation you will need to set up your template as a
protected form.  You should get a good start here and the linked articles by
Dian Chapman:

http://word.mvps.org/faqs/customization/FillinTheBlanks.htm

You can semi-automate calculations using formula fields and then updating
the fields.  Let's say the hours worked are in a column.  At the bottom put
the field {=sum(above)}.  The field code braces { } are entered with
CTRL+F9.  Toggle the field code to display the result with ALT+F9.  When a
change is made, you can update the field by selecting the field and pressing
F9, or update all fields by pressing CTRL+a (selects all) and pressing F9,
toggling to and from print preview (if "Update Fields" is checked in the
File>Print>Options dialog box), or running a macro something like:

Sub UpdateFields()
Dim oStory As Range
 For Each oStory In ActiveDocument.StoryRanges
     oStory.Fields.Update
  If oStory.StoryType <> wdMainTextStory Then
  While Not (oStory.NextStoryRange Is Nothing)
      Set oStory = oStory.NextStoryRange
      oStory.Fields.Update
  Wend
  End If
 Next oStory
Set oStory = Nothing
End Sub

Signature

Greg Maxey/Word MVP
A Peer in Peer to Peer Support

> Would like to know if it is possible and if so how to automatically
> calculate the totals for a time card template.
Suzanne S. Barnhill - 30 Dec 2004 19:04 GMT
But note that if you're trying to add times, you may need to embed an Excel
sheet instead of using Word's fields.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> CheifNewB,
>
[quoted text clipped - 29 lines]
> > Would like to know if it is possible and if so how to automatically
> > calculate the totals for a time card template.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.