A.D. Your solution was EXACTLY what I needed. THANK YOU !!!!
I tried it immediately, and IT WORKS! Gratefully, -- Jeanie --- In [email protected], "A.D.Tejpal" <[EMAIL PROTECTED]> wrote: > 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 > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
