Count number of Groups 1

[jamespeters01]

I have a table/query with one of the fields [ResearchListID] having numerous values. In my report I am grouping by this field. Can anyone tell me the easiest way to count the different groups...not what is in each group....

194
194
194

196
196
196

I would like my count to say '2' and not '1170' or '6'


Any ideas ??

 

[PaulBricker]

Add a textbox to your Group Header section. Set the Control Source to =1 and set the Running Sum property to Over All. Set the Visible property to No.
Then in your Report Footer add a textbox and set the Control Source to the name of your Running Sum text box in the Header. Something like =Text40

This will give you the count of Groups.

Paul

 

[jamespeters01]

Thank you Paul. Worked a treat