Ko,

Your result is not what I want:

Sample:
1999 01 20
1999 01 30
1999 03 40
2000 01  10
2000 01  15
2000 02  20
2000 03  10 

Result should be:
1999 01  50  2 
1999 03  90  3
2000 01  25  2
2000 02  45  3
2000 03  55  4

See the difference with your result?


>Ko,
>>
>>Interesting. I'll try tomorrow. Seems simpler, than I originally anticipated. Thanks a lot. BTW, your select seems to be incorrect, as I've analyzed now.
>>But I got the idea and try to make it work.
>

---

>Eh,
>
>Incorrect?
>What do you mean? That the output didn't give you the result you want?
>What i send you will give you the total amount from the first month to the current month like:
>month total
>01 total month01
>02 total month01 and 02
>etc.
>That's what i get out of your post.
>I'm sorry if i didn't understood you correctly.
>
>If you only want the totals per month it is much simpler.
>You only have to change the second expression in the where clause.
>The SQL i told gave the listed result.
>
>Another thing that can be done better is the arrangement of the dummy field.
>If you first place the year, and then the month you can also sort on that field.
>But i simply typed in the SQL from scratch and tried first to get it to work.