M
Milan
Dear Access users,
I deal with the following problem. In my query X, I have 2 columns: A
(ID, which is primary key) and B (sold amounts). I need to add the
column C which would represent the cumulative sum of the column B. For
example:
A B C
1 5 5
2 3 8
3 9 17
I know that I can simply get the column C by the use of function DSum
or cartesian product. The problem is that the original table is
extremely large and the calculation of query X is very time-consuming.
I would be glad if you have any suggestions. Thank you.
Milan
I deal with the following problem. In my query X, I have 2 columns: A
(ID, which is primary key) and B (sold amounts). I need to add the
column C which would represent the cumulative sum of the column B. For
example:
A B C
1 5 5
2 3 8
3 9 17
I know that I can simply get the column C by the use of function DSum
or cartesian product. The problem is that the original table is
extremely large and the calculation of query X is very time-consuming.
I would be glad if you have any suggestions. Thank you.
Milan