Running Total for every record

[leighturner]

At the top of your report's module, you will see the first line, i.e. Option Compare Database, add those other two lines just below it.

Thank you for the confirmation.

Unfortunately I am receiving "Invalid Outside Procedure" on compile.

I tried your code first, then modified to this:

Option Compare Database
Option Explicit

Private counter As Long
counter = RunTot3

If counter > 18 Then
counter = 1
End If

txtReset.Value = counter

 

[vbaInet]

You missed this sentence I made about where to put the code.

Put the code to run the counter in the Format or Print event of the Detail section: