Running Totals

[renenger]

I have a question regarding reports. I have a report that shows Date, PrdCap, WODD, CountofLot, SumofBoxesBuilt in the Date Header of the report. In the Detail I have Priority(Number), CountofLot, SumofBoxesBuilt.

If the Date < Today then the SumofBoxesBuilt is the overage and needs to populate the Difference field which is unbound.

If the Date > Today then SumofBoxesBuilt - PrdCapacity amount needs to fill the difference field. However, I need to have a running total going.

This report will show us how behind or ahead we are in our manufacturing plant. I am not sure how to do this on a report.

Also, they have requested that it do the same with the priorities.

Any ideas?



Private Sub Report_Open(Cancel As Integer)
If Me.WODD_Header < Date Then
Me.Difference = Sum(Me.SumOfPlanned_Boxes)
Else
Me.Difference = Me.SumOfPlanned_Boxes - Me.PrdCap
End If
End Sub

 

[ThreeCrow]

Place an unbound text box on you Report.

Right mouse click the on the box

Property form shows left click Data tab

in the first field put =1

last field set your Running Sum

This should get your started