Hi,
I have a report Grouped on CodeName and Sorted on CodeName with 'A on top'.
Is it possible to find the last record in a group on a report. I am thinking of a Yes/No this is the last record in this group. If so, can one then use an event such as 'on print' to set a variable.
For example:
Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer)
If Me.txtNum = Me.txtCount And Me.txtGrCount = 1 Then
Me.txtbox = ""
Else
If (this is the last record in the group) Then .... I do not know what the IF argument would be for Last Record in a Group thus the parenthesis.
me.txtbox = "Last Record"
end if
Me.txtbox= "Not the last record"
End If
End Sub
Thanks for any help.
Tom.