Sum Not Working
I used this forum last year to help generate a stock figure on a report from a form/subform.
I have now created forms to make entering the stock transactions easier for users but the stock figure on the report now generates a figure for each individual form entry
(Stock form/subform is still OK)
Stock transactions for 30/04/10 will give a Total for Stock Item 1
Stock transactions for 01/05/10 will give another Total for Stock Item 1
Instead of 1 Total for all seperate date entries
Expression on both form and report (Query)is
Stock Total = Sum(nz([Qty-Rec,d])+nz([Qty-Return])-nz([Qty-Issued
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Usually, I just sum a field at the footer of the subform with a textbox with a value of =Sum([Field]). Then I call that particular textbox on my mainform with =SubFormName.Form!ControlName. I have several of this controls already working. Each one assigned to a different subform, all of them working.
But when I did the same thing to another subform, I get a #Error in my totals textbox on the footer of my subform, it won't work anymore. So I checked and re-checked my syntax, they are all correct.
To check, I pressed the "Totals Row" feature of access 2010 in datasheet view, but could not make the sum value appear. however, the average, min, max, variance, deviation, etc. are all WORKING except for the "SUM."
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
I have a report with about 15 subreports, they all contain different cost fields, ie one is ActualCost, another is DiscountedCost, etc. Each cost field is summed in each subreports footer I.e. "=Sum(ActualCost)"
How can I get a Grand total of all the sums from all the subreports? and I don't want that to screw up the formula.
I've tried things like =Sum(ActualCost) (DiscountedCost) and =Sum(ActualCost) Sum(DiscountedCost) But nothing like that is working for me, it just asks for an input and the diplays the random number I type or Error.
The SUM of 004 should be 3808 but it comes up as 82844?
The SUM of 008 should be 88 etc.
Then the numbers seem to be adding? As the result in each column is getting bigger and bigger
This is my SQL:
This is the Result:
=([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?
The calculations from the three boxes on my report that are bringing up this error are below.
=Sum([Number of Sales])/(Sum([Appt1]/2)+Sum([Appt2])/2)
=(Sum([Sale/ renewal/ review])*100)/(Sum([number of sales
My example in attach
I use SUM(Round(value,6)) and get the result "1.19371179607697E-12". What I expect, and what has been worked out in Excell / calculator is zero. I believe that Access 97 has some mathematical issues with decimal sums? Is there a way to get the desired result?
The field type on the value is (Double, Fixed, 6dcp). I was working on this yesterday with 1dcp and was fine with smaller values