ACCESS FEED: [MS_AccessPros] Last Record of a Group in a Report

Kamis, 22 September 2011

[MS_AccessPros] Last Record of a Group in a Report

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.