ACC: How to Create a Top N Values per Group Query
Function NthInGroup(GroupID, N) ' Returns the Nth Item in GroupID for use as a Top N per group ' query criteria. Static LastGroupId, LastNthInGroup Dim ItemName, GroupIDName, GDC, SearchTable Dim SQL As String, rs As Recordset, db As ......