# Sum Not Working

Views: 15

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)

IE

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

Sponsored Links:

Thank you for taking the time to report an issue.

What's wrong... Please write below.

## More topics

### Totals and Sum not working.

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."

### VBA code to sum highlighted

### Sum function on report not working

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:

=Sum([SCHDQTY])

and I get the #Error message when I go into preview view

### How do I sum multiple sums?

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.

### SUM each individual column

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:

[CODE]

This is the Result:

### Calculating overtime in report footer

=([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?

### How do I show 0 instead of #Num! errors on my report

The calculations from the three boxes on my report that are bringing up this error are below.

=(Sum([New Appt])/2)/(Sum([Contact]))

=Sum([Number of Sales])/(Sum([Appt1]/2)+Sum([Appt2])/2)

=(Sum([Sale/ renewal/ review])*100)/(Sum([number of sales

### The Sum procedure is not working in macro

My example in attach

### Sum(Round) gives incorrect value.

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

### Sub totals in a report

MONTH

NAME SQUARE FEET SUM OWED

NAME SQUARE FEET SUM OWED

NAME SQUARE FEET SUM OWED

SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])

MONTH

NAME SQUARE FEE SUM OWED

SUBTOTAL =(Subtotal[SQ FT]) =(Subtotal[Sum])

GRAND TOTAL =(Sum[SQ FT]) =Sum[Sum])