In an MS Access query, I want one column to be the running total of another column. I tried using DSUM as explained in https://support.microsoft.com/en-us/help/290136/how-to-create-a-running-totals-query-in-microsoft-access
But that has two problems:
1) It makes the query extremely slow (The query is based on another query which takes a few seconds to run. There are about 100 records, which I guess multiplies that time taken, because the base query needs to run once for each record).
2) I am importing the output of this query into MS Excel, and I expect the data to be refreshable without even opening MS Access. Functions such as DSUM will only work within Access
Is there a way to solve both problems? I also need to solve Problem #2 for another custom function I wrote for another query.