S
Sandra Stewart
I have a table with 3 fields: Year, Month, Sales.
I want to accumulate the sales until the year changes, and
then start over. February would include jan and Feb,
March would include Jan, Feb, March, and so on until
December, which would include all the months for 2000.
Then in 2001, it would start over with the sales for
January only, then accumulate 2 months in Feb, etc.
This is easy in Excel. How can I do it in Access?
I want to accumulate the sales until the year changes, and
then start over. February would include jan and Feb,
March would include Jan, Feb, March, and so on until
December, which would include all the months for 2000.
Then in 2001, it would start over with the sales for
January only, then accumulate 2 months in Feb, etc.
This is easy in Excel. How can I do it in Access?