Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement