|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 17th, 2009, 08:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Running sum calculation
I have grouped areport by product ID and within the group do a running sum on
quantity (oquantRS). I want to test the running sum value against three values I have at the group level =IIf([oquantRS][prodTot],"NOT POSSIBLE",IIf([oquantRS][prodTot47],"Con 48",IIf([oquantRS][prodTot46],"Con 47",IIf([oquantRS][prodTot45],"Con 46","Con 45")))) Why is it flaky. It seems to work for some rows but not others Thanks 
|
|
#2
August 17th, 2009, 09:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Running sum calculation
Maybe some nulls. Try wrapping with Nz like this - Nz([prodTot46], 0)
-- Build a little, test a little. "judith" wrote: I have grouped areport by product ID and within the group do a running sum on quantity (oquantRS). I want to test the running sum value against three values I have at the group level =IIf([oquantRS][prodTot],"NOT POSSIBLE",IIf([oquantRS][prodTot47],"Con 48",IIf([oquantRS][prodTot46],"Con 47",IIf([oquantRS][prodTot45],"Con 46","Con 45")))) Why is it flaky. It seems to work for some rows but not others Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
