Report Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I only show the top three values for each group in my report?
 
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
 
It works perfectly. Thanks

Duane Hookom said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering subreports on main report 0
Sum If on Report 10
Access Sorting and grouping using multiple tables 0
Unusual Calculation in Report Header 1
repeating subreport header on report 0
Adding a field (Unbound field) that adds a group of numbers 3
Limit results on report 9
Combine 13 different reports 9

Back
Top