Report with Running Sum by week

[jbarrum]

I have a report is built off of a query that contains the following fields:

EmpName
AnnualContributionAmt
PayrollDedAmt
SumofPmts


Balance.

I would like to be able to keep a running total of how much the employee has contributed each payroll based on his deduction. The payroll is bi-weekly so there are 26 periods in the year.

the payroll dedution amount is a calculated amount based on the annual contrbutuion/26

I was hoping that I could have a field on my report that would allow me to key in the week number and it would calculate the Sum of his dedcutions but I can not find a way for this to work.

Will this work or is there a better way to go about getting this information onto my report.

[llkhoutx]

I would not save any data than can be calculated or generated by a query.

[jbarrum]

ok, I misspoke. I do not want to keep the data, but only calculate and see it. I need to be able to compare the SumDed to the SumPmts and track a running total each week.

The value can be calculated on the fly in a report or in a query. Does not matter to me as long as I can find a way to do it. I just need to find a way to write an expression that looks at the paydedamt which is his annual contribution devided by 26 and mulitply that by the number of weeks that we have had at any give time in the year.