Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Daily Cost Accumation
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... -
Daily Cost Accumation
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...
