I would like to compare one row to another, if the first row meets the criteria then row1 add row2 call this query1, if query1 meets the criteria then query1 add row3 etc.. for example
date bbls rate
2014-03-01 10 100
2014-03-02 20 100
2014-03-05 50 100
2014-03-05 30 100
using the example above: If bbls on 2014-03-01 < 100 then 2014-03-01 (bbls10) add 2014-03-02 (bbls20) query1(30)
if query1(30) < 100 then query1 add 2014-03-05 (bbls 50) query2
if query2 (80) < 100 then query2 add 2014-03-05 (bbls30) query3
if query3 > 100 then query3 - 100
I want to be able to perform this row by row calculation......
Can anyone help me please......
also, you'll attract more volunteers if you don't cut the points to the minimum.
I'm already here so no biggie -but for future questions or to get input from others you might want to bump it up.