Running Sum

[Guirg]

Hey All,

Been searching around and have found a way to have a running sum in an form found here somewhere: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q210338&ID=KB;EN-US;Q210338 is it possible to do this but only after its been filtered?

My data is a whole bunch of dates and corresponding hours of operation on that day, what i want to do is have a form that when filtered itll display the total within that range....

Any help would be amazing

Cheers
Tim

 

[ted.martin]

DSUM allows a filter criteria such that the syntax could be some like:

DSUM("[Hours]","Table1","[DateField]" between #01/01/09# and #31/01/09#)

May have to play with it a bit but in essence that should work.

 

[Guirg]

Hey

now im somewhat hoplessly confused....
I have a textbox and going to expression builder and i keep getting im missing something somewhere.... heres what im using:

=DSUM("[Hours]","frm1",varWhere2)

where varWhere2 is a public variable that i use to filter the form so it already has the requirements

Cheers
Tim