Folks,
Im not even sure if this one can be done but don't see any reason why i shouldn't be possible. I have a query which shows payments for courses, course price and bonumbers. The best way to explain is by example. say there are three payments, two for one booking and one for the other. I need to create a running sum for the two say 100 and 300 on the 300 the sum would be 400 and the third is 100 then its return would be 100. My explanation may be a bit cryptic. What i need is to create a running sum for depending what another value is.
Im not even sure if this one can be done but don't see any reason why i shouldn't be possible. I have a query which shows payments for courses, course price and bonumbers. The best way to explain is by example. say there are three payments, two for one booking and one for the other. I need to create a running sum for the two say 100 and 300 on the 300 the sum would be 400 and the third is 100 then its return would be 100. My explanation may be a bit cryptic. What i need is to create a running sum for depending what another value is.
