Dear max1x
Thanks 4 your direction. let me show the query i made. It works if datestart and finishstart in 1 month (e.g.month=6). I use UNION to combine them, it's mean i will use 11 union to combine them! it will overload MySQL. 1 month is 4 cost. cost is sum in 1 week. But this Query start to...
Hi All,
I have just 3 Field.
DateStart(date),DateFinish(date),Cost(double)
How can I make Output is Cost Accumulation per day like
Day1=Cost Which SUM all UnitCost within Day#1
Day2=Cost Which SUM all UnitCost within Day#2
Day3=Cost Which SUM all UnitCost within Day#3
..and so on until the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.