Add Text Box with Sum Function to Report
SummarybyChannelType-LessThan60 is a Query
SumofAssetCost is a field derived in that query
When I added it to my report a view it, the text box displays "#ERROR
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am trying to Sum up one field called SCHDQTY. On the textbox I am trying to put the total into, I have this as the control source:
and I get the #Error message when I go into preview view
=Avg(((([Sum Qty]*[Rate])*(0.125))/[Sum Hrs])/[Employee Data_Rate])
When I run the report I get a box that tells me to enter the parameter value for Sum Qty and Sum Hrs. These two are calculated text boxes that gets the sum of the Qty and the Hrs. I realize that you can't use these with the Avg function but I don't know any other way to do it. I tried putting the Sum function inside the above formula but got an error message as well. What would be the best way to to get my report footer to show the proper average of these numbers?
=([On Std Hours Sum] [Off Std Hours Sum] IIf([On Std Hours Sum] [Off Std
Hours Sum]40,0.5*([On Std Hours Sum] [On Std Hours Sum]-40),0))*[Current Pay Rate]
I should note that the [On Std Hours Sum] and [Off Std Hours Sum] are both sums (if you didn't already catch that!) Now, I need a sum of that formula in the report footer but as you know you can't sum a sum. I attempted to use the totals function inside the query that I have based this report on to sum the On and Off Std Hours but it only shows the last entry for each employee. Any ideas on how I can sum the above code properly?
I have a text box in the detail section of the main report with the control source set to the subtotal located in subreport report footer.
This works fine.
When I try to sum txtDetailTotal in the report header or footer I am queried for the value of txtDetailTotal and no value is displayed.
My guess is that the sub form is not calculated prior to the main report sum function.
As a work around I'm going to add a sum of the details to the main report and see if it works
This is part of an text box calculating as part of a footer.
After solving this I may need to extend this question into summing a text box later. We'll see.
which doesn't seem to work either. Any way I type it, no value shows at all.
My report(detail section) displays the running balance, the report footer calculates the sum per colunm, and I will like to add a text box the displays below the running balance the last balance as the total balance. If you open report, enter 1 as the parementer and go to second page
In the subreport I have added a text box where I created the formula (=[TotalReceived]*[UnitPrice])
Can I sum the text box? I guess the question I have is can I create a calculated text box and then sum that control in the footer of the report?
I know how to do it in thing like excel but I dont know how to do it in access. in excel it would be =sum(a+b+c+d)
and this will update in realtime. I have tried this in the default and control source in the text box properties but it does not seem to work. it seems to know the expression =sum() but as I enter values into the a b c & d boxes it dosnt update.
But when I add the 2nd Criteria (the FBCS part) I get errors. Any suggestions on how I can add this 2nd criteria to sum. I know I can create more queries and then add them together, but would like to simplify this