Getting the Total after a result

[rjbautista20]

Hi Again to All,

I would to have a query that's compute its total value until the it became negative.hope you can help me again.


How can i do this in query?



Thanks

E.G.
US1 30,222,277.00 98,795,667.00 (70,263,209.00) US1 30,222,277.00 346,798.00 28,532,458.00 US1 30,222,277.00 21,367.00 28,879,256.00 US1 30,222,277.00 1,321,654.00 28,900,623.00

[June7]

Don't understand. Sum until the sum is negative or until a negative value is encountered?

[rjbautista20]

@june7 thanks again for the reply.

Ex:

1,000 - 300 result is 700
query should base on the result which 700, next row should look like this.
700 - 200 result is 500 then
500 - 600 result is -100 and query should stop now.

Thanks.

[June7]

You need to calculate consecutive records. This can be done in a report with the RunningSum property of textbox. Or in a query with this method http://allenbrowne.com/subquery-01.html#AnotherRecord

I don't think a query can be 'stopped' based on some condition. You would have to fiilter the records.

[rjbautista20]

hi @june7,

since the output of my query will be on excel, I created a temp sheet and do the running balance. and glad it's working already.

Thanks for your help.