I'm trying to do a running sum of a column using DSUM function. Unfortunately, it doesnt give the answer that i want.
I have a table with 4 fields -> [OrderID], [Date], [Customer], [Amount].
And i'm trying to display the running sum of [Amount] field. So, i created a form n use the DSUM function. But instead of getting a line-by-line running sum, i get a line-by-line Grant Total of [Amount]
The formula i used is DSUM("[Amount]","QueryName").