3 replies
by ktirf
I assume that we have a table "Table_Name" with columns ID, VALUE, DATE. Hope you'll make it even if the date is not in one field; if not, mail me. Anyway, if you want to make a total for a month you use "Sum(VALUE)" with "group by Month(DATE)" or kinda, yeah? Now, to obtain a running total, fill the field reserved for it with something like this:
DSum("VALUE", "Table_Name", "DATE Between " & DATE & " And " & DateAdd("m", -1, DATE))
Do you see? You use the current date and the date a month earlier to determine the recordset you need a running sum of. And then you use DSum function to sum all this!
I must confess I did not try it, but I believe it works. Cheers!
by jay aldous
by jay aldous
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending