Re: Conditional Running Sum

Salad,
Please see Query2 output above. I can not get correct output with your
advice.
I dont know what to do
Thanks for your posting anyway

Re: Conditional Running Sum

mezzanine1974 wrote:
> Salad,
> Please see Query2 output above. I can not get correct output with your
> advice.
> I dont know what to do
> Thanks for your posting anyway

SD = SortDate, FDt = FromDt, TDt = ToDate

SELECT Table13.SD, Table13.FDt, Table13.TDt, Table13.Money,
DSum("Money","Table13","SD <= #" & [SD] & "#") AS Expr1
FROM Table13;

I get, using your data,
1/1/2008 $1
2/1/2008 $1
3/1/2008 $10
4/1/2008 $13
5/1/2008 $13

Don't know what's required to get the output your desire...appears data
drops off based on conditions. My recommendation is to create a
function that uses your logic to return the results. ExL
GetSum : CalcRunSum([SortDate])
and with the sortdate processes that data in function CalcRunSum.

BTW, your snipping of the posts...especially the important stuff, wastes
my time and would waste the time of anyone that would want to respond to
you. If you want help, think.