first 5 records

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

Hi Guys

I have a reports sorted and grouped by the field machine, but in the detail
I just want to show the first 5 records for that group. Any help will be
appreciated

Thanks
 
Consider adding a text box to the detail section:
Name: txtCountGroup
Control Source: =1
Running Sum: Over Group
Visible: No
Then add code (module window) to the On Format event of the section:
Cancel = Me.txtCountGroup > 5
 
Back
Top