Search results

sorry i can't post an image of the data in the query. As it stands the code does a cumulative sum from month 1 to month 12, however month 1 is January 2014 but i need it to start at July 2013 as the first in the cumulative total. What i am getting is this Jul 1206 Aug 1307 Sep 1352 Oct 1491...

Hi, I have set up a form on which there is a graph which draws data from a query. I have set up a text boxes to take in the Y axis min, max and interval values so the user can customize the graph according tot he range coming out of the query. This all works fine and is perfect, however, i also...

That's what i had originally but i need the cumulative total sequentially by year and month as below. yYear mMonth Monthly Total CumTotal NEW 2013 7 45 1206 45 2013 8 101.8 1307.8 146.8 2013 9 44.5 1352.3 191.3 2013 10 139 1491.3 330.3 2013 11 169...

Thanks vbaInet, its closer but not quite yet what i need. Its doing cumulative sums per year but i need overall cumulative sum ie from July 2013 to August 2014 (this are user specified via a form and change all the time) Would appreciate further assistance Cheers yYear mMonth MonthlyTotal...

It is only giving me the overall total with the following: CumTotal: Val(Format((DSum("[Monthly Total]","[q_WQ_Rainfall_Dates1]","[yYear]<=" & "[mMonth]<=" & [yYear] & [mMonth] & ""))))

I have tried that but cannot get the syntax/code right, can you help me out?

Hi i am trying to run a cumulative total for each month spanning different years. unfortunately i cannot get the order correct for the DSum calculation as it orders by month only and i cannot figure out how to order by year and month. I thought about adding in a temporary sequential number and...

Hi, I have some charts for which i have set up text boxes to specify the max and min y axis values as well as the major unit increment. This works well and i am happy with it. However, i would like to have the option to reset the charts to autoscaleing via a command button. I have set up...