Break

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

Guest

I would like to have a break with a sum after the first 15 records and then
after the next 35 records and then after the rest of the records. How do I do?
 
I would like to have a break with a sum after the first 15 records and then
after the next 35 records and then after the rest of the records. How do I do?
Click to expand...

What kind of a break?
An extra line? A Page Break?
Also, this part (and then after the rest of the records.) is not very
clear. You do not wish any further breaks after the 35 until the end,
or you wish a break after each additional record?
 
Hello Fredg
It's about our costumers turnover. I would like a summary over the first 15
customers turnover, and then a summary over the next 35 customers, and then
a summury over the rest of the customers. (in the file I have a record for
each customer and a field with their turnover)

"fredg" skrev:
 
I would place these controls in your detail section:
Control Type: PageBreak
Name: pgBreak
Visible: No
Top: (at the very bottom of your detail section)

Control Type: Text Box
Name: txtCount
Control Source: =1
Running Sum: Over All
Visible: No

Then add code to the On Format event of the detail section:

Me.pgBreak.Visible = (Me.txtCount = 15 or Me.txtCount = 50)
 
Back
Top