Calculated control

[Goingcrazy]

Hi,
I have a form called service info with a subform within it called service times. On the subform I have the field TotalTime which is calculated from the timein timeout fields. I need to get the sum of TotalTime and then be able to calculate it on the main form to figure out the total cost of each service. I have been searching this and still need help. If anyone could explain to me what im supposed to be doing to fix this i would really appreciate it.

 

[Goingcrazy]

Nevermind.... I found the help that I needed.

 

[missinglinq]

Forum etiquette dictates that if you post a question and then figure out the solution yourself or find the answer elsewhere that you post that solution. That way, others searching for answers to similar questions can benefit from your experience!

Glad you found a solution!

 

[Goingcrazy]

Found the answer here!

Here is where i Found the solution to my problem. Hope this helps.
http://www.databasedev.co.uk/subform-total.html

 

[themurph2000]

Here is where i Found the solution to my problem. Hope this helps.
http://www.databasedev.co.uk/subform-total.html

And the fact that this was the EXACT help I was looking for is why you always post it. Thanks for the info.

CORRECTION: I spoke too soon. I attempted to hook up this information to my own form/subform, which has an employee's information in the form and entries for vacation time in the subform. In the subform, I created the summation text box in the subform's footer and set it to not visible. However, I linked up a text box in the main form to display this, and I still get the same #Name error I was getting before when I was trying to link a summation query to the form that did the same job. (I checked to make sure everything was spelled right.)

Any suggestions, campers?

 

[Goingcrazy]

Hey Murph, Im so glad that it helped! it actually was the exact help i needed too.

 

[themurph2000]

Hey Murph, Im so glad that it helped! it actually was the exact help i needed too.

Actually, it worked once I went through the Expression Builder to reference the text box in the subform. For whatever reason, it only works when I put the original name of the subform, which had spaces in between the words. The new name didn't work for some weird reason.

 

[Goingcrazy]

Actually, it worked once I went through the Expression Builder to reference the text box in the subform. For whatever reason, it only works when I put the original name of the subform, which had spaces in between the words. The new name didn't work for some weird reason.

If you renamed your subform then i think you may have misunderstood the site. you needed to only name the subforms summation control. well either way as long as its working now Im glad you found what you needed.

 

[themurph2000]

If you renamed your subform then i think you may have misunderstood the site. you needed to only name the subforms summation control. well either way as long as its working now Im glad you found what you needed.

Right, but you still need the name of the subform as part of the equation. The renaming of the subform took place long before I started doing this.

 

[Goingcrazy]

I see. when you open the subform on the menubar do you see the old name or the new one? if you see the old one then maybe that is why it didnt use your new name in the equation. I really dont know. sorry.

 

[themurph2000]

I see. when you open the subform on the menubar do you see the old name or the new one? if you see the old one then maybe that is why it didnt use your new name in the equation. I really dont know. sorry.

I found out where I went wrong. I kept searching directly in the subform without checking the original form and the link to the subform. The spelling was wrong there. All corrected now.

 

[Goingcrazy]

glad u figured it out!