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() ?

 

[Pat Hartman]

Are you asking for a running sum? If so, you MUST have a unique identifier in the record. Do you have one? If not, you can create a running sum in a report or VBA code but without an "anchor", you won't be able to do it in a query. A Running sum sums all the records "before" this one. In order to get the records in a specific order and keep them there, you need something unique on which to sort. Both a report and a VBA loop can work on physical order which may or may not produce the results you are looking for.

 

[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;

 

[Pat Hartman]

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

 

[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.