The issue with DSUM: not calculating as expected

[Gasman]

i have attached the sample DB above. Kindly work it out on Balance as indicated in the above posts. much appreciated...

No, that is for you to do. I am just trying to show you how. If everyone does your work for you, you learn nothing and just come back for more.
@arnelgp seems to have done that for you now anyway?

 

[sibbbra]

what is wrong with the calculation, you said it is 342001 is the second line?
View attachment 107665

the problem is that the rest of enteries has false calculations. check that

 

[sibbbra]

what is wrong with the calculation, you said it is 342001 is the second line?
View attachment 107665

check this. a few examples

 

[sibbbra]

what is wrong with the calculation, you said it is 342001 is the second line?
View attachment 107665

check this

 

[sibbbra]

nothing helped out yet. problem is still there

 

[Gasman]

TBH, until you get something that you can definitively know is incrementing, I do not believe you can do it.

Most would use the ID which generally is incrementing, but yours is all over the place? so that is not an option.

Microsoft Access Tutorial: Row Number in a Query

In this tutorial, you will learn about how to add a Row Number in your Query.

www.599cd.com

 

[arnelgp]

test this again.

 

[Gasman]

test this again.

Nice one @arnelgp

 

[sibbbra]

test this again.

wonderful

arnelgp​

I have no proper words to thank you. I am grateful . best wishes

 

[sibbbra]

test this again.

hi, by the way, if I want to use this on any report, what are the steps and whats the code and how... plz.
Thanx

 

[sibbbra]

test this again.

can u plz define, what are the steps to use your method.. thanx