Creating a Month to Date formula

[DivaSupreme]

If I have a table that has a "Date" field and a field for "Terminated Employees" (which will store a the # of terms for that date), how can I create a field in a report that will calculate the total for the "Terminated Employees" that returns a month to date value? I am not famialir with VBA..... any help that can be provided will be appreciated.

 

[MichaelRed]

See running sum in Ms. Access Help. It is a property of textbox controls (and others?). Generally this uses two controls. one in the detail which is hidden and one in the footer, which is visible, with it's control source set to the hidden control.

Annother approach is to use DSum(). You will need to look up the help on this. I do not usually employ this as, in my experience, it is very slow.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over