Hello there!

I have following problem: My database primary field is a date. I do entrys just like in a diary. For each entry, I can choose the select field 1 or select field 2 as type. Now I want to count all input fields in concurrence between select field 1 and select field 2 and display it in a third field.

So for example:

Name / Input Field / Accumulated

Select field 1 - empty - empty

Select field 2 - 100 - 100

Select field 2 - 150 - 250

Select field 2 - 125 - 375

Select field 2 - 25 - 400

Select field 2 - 100 - 500

Select field 1 - empty - empty

Select field 2 - 50 - 50

Select field 2 - 100 - 150

…

I know want a third field that displays the sum or accumulated value of input field between the two select field 1. The table is sorted by the date field.

Is this in any way possible?

Thanks!