Report Help

[Mrs. Batton]

How do I only show the top three values for each group in my report?

 

[Duane Hookom]

I would add a text box to the detail section of your report:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No
Then add code to the On Format event of the detail section:
'(This goes in the module window)
Cancel = Me.txtCount>3

 

[Mrs. Batton]

It works perfectly. Thanks

I would add a text box to the detail section of your report:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No
Then add code to the On Format event of the detail section:
'(This goes in the module window)
Cancel = Me.txtCount>3