Access to calculate cumulative sum in Query - DSUM performance very slow

[Icecream]

I am designing an Access loan program and need to build up a query to show the cumulative payment amount of principal for subsequent calculation, and I use a function “DSUM” for this purpose. But the performance of this function is very slow and unacceptable for only around 20 loan data so I need to find alternative to replace this function. I know that to show the cumulative sum in report is simple and fast, but I need to show the cumulative sum in query.

Can somebody suggest alternative ways to replace the DSUM function to calculate cumulative sum in Query? Thank you very much!

 

[arnelgp]

can you show us the SQL statement of your query.

 

[gemma-the-husky]

personally, I would avoid trying to get cumulative/running sum in a query. (and maybe not even in a form). Reports do this simply, because reports are fixed and sequential.

Other objects only with a lot of difficulty, because they are not fixed and not sequential - ie what happens to your cumulative totals if you resort or filter the data, or delete a row, or insert a row, or edit a value here and there?