Client Account Register Balance yearly total

[adtastichosting]

The Client Account Register Balance, aka Client Statement is good as it shows monthly amounts and total paid. But the yearly total is not for the year you are looking at it is for the entire history to date eg, ending balance. And there is nothing that shows a total for the year in question, If a client wants to know how much money or you need to know how much money a client has spent just for a given year you have to manually add each month or as in the case of a full year I suppose you can look at the previous year then the next year and subtract the difference. Would be nice if you can have a total spent for the year. and only the year in question. Makes it especially nice when a client says "I spent this much this year" and the actual is different than they think so you can easily generate a statement that shows the actual not the aggregate.

[Kian]

You could...

 

SELECT SUM(total) AS total FROM tblinvoices WHERE YEAR(date) = '2014' AND status = 'Paid' GROUP BY userid