Hi there, I currently have a report that counts the number of occurrences of a specific value in a field.  to do this I have grouped on that field and inserted a  summary.

Now I would like to use this summary as a group and count the number of times that appears.

So if I currently get

abc 3
def 3
ghi 2
jkl 4
mno 3
pqr 4

and I would like to get

3 3
4 2
2 1

Thanks in advance.

Stu

Thanks for your response Keikoku, I was pulling the data from a read only SQL database. 

Managed to get round it by adding a virtual/command table to the report, works great now.

Thanks,
Stu