Solved Sum total 1 column

[KoskeKos]

Hi.
I need to run trough rows,
sum total value in column and
use that value for further calculations.

 

[jdraw]

?? More info needed??
What do the various records(lines) represent?

 

[Gasman]

Use DSum() ?

 

[KoskeKos]

Thank you all and Sorry for delay...This is situation:
I have

I need sum InitExposure_Gross column
and use that value for further calculations.

 

[XPS35]

Use the DSum function.

YourVar = DSum("InitExposure_Gross", "YourTable")

 

[arnelgp]

I need to run trough rows,
sum total value in column

use Total Query:

SELECT ID_CLIENT, SUM(InitExposure_Gross) As SumExposure FROM yourTableName
GROUP BY ID_CLIENT;

 

[KoskeKos]

You didn't answer my question regarding a running sum. The other people are guessing as to what you actually need. Please post a picture of the results you want.

@XPS35 assumed you wanted ONE figure and that was the sum of all the rows in the table AND you wanted it for use in VBA
@arnelgp assumed you wanted the results in a query with one line for each client and a sum of the column for that client

Sorry for lack of info.
Data come in once a month. I need to sum last column "InitExposure_Gross". Thats why i posted second picture (first time i did it in hurry ). I realized that i had Date field for "anchor". I will try to use XPS35 solution cause i think it will do the job.
And if dont, i'll buy beer for everyone. Cold.