Running sum with changing colors?

[herbertioz]

I have now a label with =1 in it, and running sum "All".

So the report print out:
1
2
3
4
5
6
7
and so on.

How can I count this records and put it in a variable?
I want to calculate 25% of the record and set a red color to them.

 

[apr pillai]

1. Open the Report in Design View.
2. Insert a TextBox on the Header of the Report.
3. Insert the expression =DCount("*","Report Source Table/Query Name") .
4. Change the Name Property Value of the Textbox to TCOUNT.
5. Set the Visible Property Value to No.
6. Create another Textbox near to the earlier one.
7. Write the expression =INT([TCOUNT]/4) in the Control Source Property.
8. Change the Name Property Value to REDCOUNT.
9. Change the Visible Property Value to No
10. Click on the Textbox, where the Running Sum value is appearing, to select it.
11. Select Conditional Formatting Option.
12. Set Field Value is Less than or Equal to [REDCOUNT] in the three segment controls under Condition 1.
13. Select the Font Color Red and if necessary set it to Bold.
14. You can Repeat Step-10 to 13 for other controls, if required.

 

[herbertioz]

Thank you very much

I used =Count([Fieldname] instead

 

[vbaInet]

=Count(*) should do. More effecient.