Cumulative Calculation of Column

[Kumarsan]

Hello Team,

This Santhosh Kumar I basically work in Finance and new person to MS access.
I am trying a build a query with cumulative numbers in a column in MS Access and was not successful. Hence i seek the help of experts
I have attached the excel and i need to achieve the same column B as in excel in access.

Please help me in building this query.

Also Let me know if any more Information is required.

Regards
Santhosh

 

[NauticalGent]

Hello Santhosh and welcome to the forum.

On quick question if I may; Is the excel example you provided the full extent of what you want to in Access? If the answer is yes and you will be the only one inputing the numbers, keeping with excel may be a more practical option.

 

[arnelgp]

you must add an autonumber field in your table in order for this to work:

select T1.index, T1.[amount in gc], (select sum([amount in gc]) from table1 where table1.autonumberfield <= T1.autonumberfield) AS cummulative FROM table1 AS T1;

replace table1 with correct table name.

 

[NauticalGent]

Also, I forgot to ask what version of Access you are using. Version > 2007 have a sum feature in table/datasheet view.