Formula on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is briefly set up like this:

WE MD
2/06/05 169
2/13/05 145
2/20/05 189
2/27/05 104
Feb TTL 607

3/06/05 133
3/13/05 50
3/20/05 107
3/27/05 351
Mar TTL 641

WeekEnd, MonthEnd, and MD are my controls. What I need is a formula on each
month end that adds this months total MD with last months total MD. For
instance in my example I would need a column to the right of Mar TTL 641
that adds 641+607. Is this possible in Access and if so how? Thanks for any
help.
 
Working with grouping in Access reports, this is very possible. I'm
assuming that your monthly totals are the result of a sum function in the
footer section of a group. I think you want a running total of those sums.
Copy the textbox which contains the sum function for your MD field. Under
the data properties tab, change the running sum property to "Over group".

Linda
 
Back
Top