I have a report where a cycle time of a machine is multiplied by the hours run in order to get a total pieces. Is it possible to put a total of each detail "so far" in the details section? putting a sum in the footer is no good, I need an idea of how many total pcs are added with each record.
adding details before footer
- Thread starter red91
- Start date
Fornatian
Dim Person
- Local time
- Today, 22:58
- Joined
- Sep 1, 2000
- Messages
- 1,396
If changing the running sum property to Yes doesn't work as the field is not bound you will have to do it yourself in VBA
Store a local long integer variable in the report holding the TotalSoFar. In the OnPrint event calculate the running total 'manually' something like:
Dim lngTotalSoFar as Long
Dim lngThisRecordValue as Long
lngThisRecordValue = Me.CycleTime * Me.Hours
lngTotalSoFar = lngTotalSoFar + lngThisRecordValue
Me.RunningSumBox = lngTotalSoFar
HopeThatHelps
Store a local long integer variable in the report holding the TotalSoFar. In the OnPrint event calculate the running total 'manually' something like:
Dim lngTotalSoFar as Long
Dim lngThisRecordValue as Long
lngThisRecordValue = Me.CycleTime * Me.Hours
lngTotalSoFar = lngTotalSoFar + lngThisRecordValue
Me.RunningSumBox = lngTotalSoFar
HopeThatHelps
