I have a crosstab query that uses "month" as the column heading - My row's are "year" and "county".
Therefore, my results look like this:
2002 January February March
Camden 25 10 11
Burlington 14 32 9
What I want to do is run a cumlative from month to month so I can run a chart. Is there an easy way to do this or will I have to add text boxes for each month and sum the previous text box as I go left to right.
Hope that makes sense -thanks for the help!!!
Fred
Therefore, my results look like this:
2002 January February March
Camden 25 10 11
Burlington 14 32 9
What I want to do is run a cumlative from month to month so I can run a chart. Is there an easy way to do this or will I have to add text boxes for each month and sum the previous text box as I go left to right.
Hope that makes sense -thanks for the help!!!
Fred
