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.

hi Tracy,

Word really isn't the right tool for this. Excel is much better suited to the task and can perform it without the need for macros.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Adding my two cents...

Paul is right. You should use Excel. It is likely "possible" in Word, but it would take a LOT of work, a lot of code, and a lot of development and testing. It simply is not worth the effort.

It is the proverbial sledgehammer to put in a screw.