On 14 May 2012, at 15:29, Jonathan Fletcher wrote:
> Sorry. Answered too fast. That was wrong.
Jonathan
Was it so wrong?
I think John could add a new field to each record as you suggested: boxCount = ValueCount ( chckBoxField )
Then add another calculated field to use as a counter: unity = 1
Plus a summary field to add up the counters: sum = sum (unity)
Use a layout with only a subsummary part set as "when sorted by boxCount". On the subsummary part you can use merge fields, I believe, like:
<<sum>> records with << boxCount >> boxes checked
Make sure your found set is sorted by boxCount and that should be it.
Untested!
Steve