Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-23-2013, 02:05 PM
Tracy Lynn Tracy Lynn is offline Microsoft Word Calculations and Dropdown Fields Windows XP Microsoft Word Calculations and Dropdown Fields Office 2007
Novice
Microsoft Word Calculations and Dropdown Fields
 
Join Date: Jun 2013
Posts: 4
Tracy Lynn is on a distinguished road
Default Microsoft Word Calculations and Dropdown Fields

I am trying to sum the results of two tables which use dropdown fields in one column and then a numeric entry in the other. The fields in the dropdown fields are IA, PH, OH, WT, AJ, NE, PL, TR, ST, CO, MC, CC, LR, IW, IP, IV, TR, and OO. These are the time codes which the user selects to categorize their time.



The column next to it is a text field and allows the form user to enter their time spent according to time code.

What I need to be able to do is to total the time according to each time code in another table. For example, I need to sum all of the IAs, the PHs, etc in another table underneath each category.

This is in Word 2007.

Last edited by Tracy Lynn; 06-23-2013 at 07:40 PM. Reason: Moving Thread to the VBA Programming Section
Reply With Quote
  #2  
Old 06-25-2013, 08:23 AM
Gary Drumm Gary Drumm is offline Microsoft Word Calculations and Dropdown Fields Windows XP Microsoft Word Calculations and Dropdown Fields Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

Do you have the option to do it in Excel?
If so, I believe a look up table would work.
Reply With Quote
  #3  
Old 06-25-2013, 11:50 AM
Tracy Lynn Tracy Lynn is offline Microsoft Word Calculations and Dropdown Fields Windows XP Microsoft Word Calculations and Dropdown Fields Office 2007
Novice
Microsoft Word Calculations and Dropdown Fields
 
Join Date: Jun 2013
Posts: 4
Tracy Lynn is on a distinguished road
Default

No. The form was designed as a Word document.
Reply With Quote
  #4  
Old 06-25-2013, 11:50 AM
Tracy Lynn Tracy Lynn is offline Microsoft Word Calculations and Dropdown Fields Windows XP Microsoft Word Calculations and Dropdown Fields Office 2007
Novice
Microsoft Word Calculations and Dropdown Fields
 
Join Date: Jun 2013
Posts: 4
Tracy Lynn is on a distinguished road
Default

I can do the formula in Excel, but not Word.
Reply With Quote
  #5  
Old 06-26-2013, 07:36 AM
Gary Drumm Gary Drumm is offline Microsoft Word Calculations and Dropdown Fields Windows XP Microsoft Word Calculations and Dropdown Fields Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

Tracy,
I found a MS Help file, but cannot uplaod it (security token is missing)?
Anyway, press f1, and seach for sum in Word Table.
I saved a copy for potentail future use.
Thanks,
Gary
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Word Calculations and Dropdown Fields Date fields calculations in Word Template. kckay Word 1 10-22-2012 11:34 PM
Word 2010 - DOCX File with fields -> PDF with fields senglory Word 2 03-27-2012 10:10 AM
30+ days Variable Day Date Calculations via Fields ztag Word 2 01-06-2012 11:12 AM
Microsoft Word Calculations and Dropdown Fields Issues with Microsoft Word Form Fields hbforsyth Word 9 11-14-2011 04:26 PM
Calculating Form Fields in Microsoft Word wubba80 Word 1 06-25-2010 12:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft