General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only