how do i limit the number of records on the detail section of a r.

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

Guest

i have a table of stores, products & sales value. each store can sell up to
500 products. i want to produce a report, grouped by store showing only the
top 15 products by sales value.

can anyone help?
 
One method is to add a text box to the detail section:
Name: txtCount
Control Source: =1
Running Sum: Over Group
Visible: No

Add code to the On Format event of the detail section:
Cancel = Me.txtCount >15
 
Back
Top