Fill-In Form Calculations

S

STC1

It seems like it should be simple but my calculations are doubling
I am using the following as
Rate1 defined as a number, calculate on Exit
Hours1 defined as a number, calculate on Exit
Total 1 defined as a calculation, =product(Rate1, Hours1
I have 5 groups of numbers (Rate2, Hours2, Rate3, Hours3, etc.
My TotalTot is a calculation =sum(Total1,Total2,Total3,Total4,Total5
The End Result (TotalTot) is doubled
I have spent too much time trying to figure this out and I must give up; any suggestions would be GREAT
THANKS
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?U1RDMQ==?=,
It seems like it should be simple but my calculations are doubling.
Click to expand...
This is a known problem. See my reply in the thread "Calculations
Word but Give Wrong Numbers", from yesterday, for the two approaches
you can use to solve this.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional sum question 3
Accsess Form 3
Iif not working for multiple options 10
Missing operator error in print routine?? 2
Forms Calculations 1
Text Form Field Calculation in a Protected Document 3
Calculation in Protected Form 1
Date Time Group Math 3

Top