Problems using a sum forumula 1

[Gaffi1]

I didn't realize I put the post in the wrong spot, so I'm posting a new thread. Here is the thread to my original post to give you background of my problem.

http://www.tek-tips.com/viewthread.cfm?qid=919698

In sumation, I created a text box formula in a group footer to sum a calculation in another text box in the detail section, and it's not working. Looking for a workaround to the problem. Thanks!

 

[sfm6s524]

Maybe try this. If the Name of the calculated detail control you are trying to total is txtWtAvg1, create another control in the detail section named txtWtAvg1RunSum, set it's ControlSource to =txtWtAvg1, Visible property set to False, and it's RunningSum property set to Over Group. On the Group footer, for the textbox used to total the calculated detail control, set it's ControlSource to =txtWtAvg1RunSum.

Ken

 

[dhookom]

Gaffi1,
You can't sum a control (as you found out). Did you try to sum the calculation from the text box in the detail section? For instance, if the calculation is:
=UnitPrice * Quantity
then try:
=Sum(UnitPrice * Quantity)


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Gaffi1]

Boy, was this so simple it was sad to fix...
First we created a sum of hoursworked query.
Then we created a query pulling the information from the table.
Joined the unique identifiers (this case was SS) through join properties.
Added the SumHoursWorked from the sum query into the query pulling the information from the table.
Then added 3 more calculated columns like Weighted: [Hoursworked]/[SumHoursWorked].
Then, we created our report off of that query, and were able to sum the weighted efficiencies, giving us weighted averages.

So, we may not have covered that in this thread, but after looking through 20 or so different threads we learned what we needed to accomplish this report and we're being heralded as heros for the company. Thanks so much everyone for your help!!! Hope this will help all those who have the same problem in the future cause we saw lots of people with this problem...