> Jeanie,
>
> Following
sub-routine in Detail_Format event of the report should be able to get you the
desired results.
>
> TxtGrpCount is the
name of text box serving as counter for the group in question (i.e. _expression_
as =1 and running sum property as "over group").
>
> Best
wishes,
> A.D.Tejpal
>
>
====================================
> Private Sub Detail_Format(Cancel
As Integer,
_
>
FormatCount As Integer)
> If TxtGrpCount > 4
Then
> Detail.Visible =
False
>
Else
> Detail.Visible =
True
> End If
> End Sub
>
====================================
>
> -----
Original Message -----
> From: Jeanie S
> To:
[email protected]
> Sent: Monday, September 26, 2005
17:50
> Subject: [AccessDevelopers] Re: row number for query
result +
Limit
>
>
> Thanks, Luis.
The only problem with that is that I need the top
4 in
> EACH class and the class is only separated from within
the
Report.
> The qryResults finds all of the
boats in the event that have
> finished, then the Report
separates by Division and then Class
within
> the
Division.
>
Event
> .. Division
1
> ... Class
A
> ... Class
B
> .. Division
2
> ... Class
A
> ... Class
B
> ... Class
C
> ... Class
D
> I need the top 4 in each Class, within the
Divisions. Selecting
the
> Top 4, ascending from
within the query gives me 4 records only.
In
>
this case, it was the first place in Div 1, Class A; and the
first
> place in Div 2 Classes A, C & D.
>
> There must be something in the driver code for the report
that I
can
> adjust, but I can't find anywhere to do
that.
>
> Anyone?
>
> --
Jeanie
