Suppose one id in table contain data from 1/1/19000. I need to create a query that sum every day data the previous record make cumulatives. if i run the query to date it sum the data from 1/1/19000 to date on range based not cumulative and showing one figure. 2. Month to date = Suppose october 2012 is the month if irun the query till 23rd october 2012 it cumulate the data on range bases. 3. year to date= reterive records if my date is 7/1/2010 then query acumulate the data from 1/1/2010 to 7/1/2010 on range based.
Suppose one id in table contain data from 1/1/19000. I need to create a query that sum every day data the previous record make cumulatives. if i run the query to date it sum the data from 1/1/19000 to date on range based not cumulative and showing one figure. 2. Month to date = Suppose october 2012 is the month if irun the query till 23rd october 2012 it cumulate the data on range bases. 3. year to date= reterive records if my date is 7/1/2010 then query acumulate the data from 1/1/2010 to 7/1/2010 on range based.
Sorry my english not good.
Hameed
Hello Hameed,
it isn't a matter of good or bad english to give table structure, sample data and wanted result.
Please try to give table structure, sample data and wanted result.
date based query
Posted - 10/24/2012 : 03:40:32
