The_Vincester
Registered User.
- Local time
- Today, 02:59
- Joined
- Jun 6, 2006
- Messages
- 71
I have a form based on a query. The query take entries from a table on sums them.... not a problem.
Now I make the form, and I want to use the two summed fields and divide them to get a completion percentage. Easy enough, right? I created a field with the control =[sum1]/[sum2] and set the formate to percentage. It works fine (it's inline by the way, not in the footer as I need it for each separate day). That is, it "kind of" works fine. It won't calculate the individual fields unless I "mouse over" the fields, then it calculates no problem. If I don't mouse over, it just sits with "Calculating . . ." in the bottom left corner.
What am I experiencing here? It also causes some other weird bugs that are related to this calculation. Should I be doing something different?
Now I make the form, and I want to use the two summed fields and divide them to get a completion percentage. Easy enough, right? I created a field with the control =[sum1]/[sum2] and set the formate to percentage. It works fine (it's inline by the way, not in the footer as I need it for each separate day). That is, it "kind of" works fine. It won't calculate the individual fields unless I "mouse over" the fields, then it calculates no problem. If I don't mouse over, it just sits with "Calculating . . ." in the bottom left corner.
What am I experiencing here? It also causes some other weird bugs that are related to this calculation. Should I be doing something different?
